Data matching & appending in Excel or SQL

This project was successfully completed by ramyrafik for $10 AUD in a day.

Get free quotes for a project like this
Project Budget
$10 - $30 AUD
Completed In
1 day
Total Bids
Project Description

Small project- looking for bids of $10

Need someone to setup queries so a master list column is referred to and based on provided keywords (most with wild card front and back) append associated flaggings.


• % represents wild card. For example, sm%th finds "smith" and "smyth". Also %east finds "Northeast" and "Southeast"

• where % does not exist, there is no wild card

• space sensitive (Very Important)

• not case sensitive

• where there is more than one 'Job Folders' or 'Job Level' separate with ; in the same cell.

• conditions include where a keyword exists or where a keyword does not exist -append a code.

See attached for production file. Let me know if you have any questions.

Completed by:

Looking to make some money?

  • Set your budget and the timeframe
  • Outline your proposal
  • Get paid for your work

Hire Freelancers who also bid on this project

    • Forbes
    • The New York Times
    • Time
    • Wall Street Journal
    • Times Online