Excel Lookup Function

This project was awarded to nagybatonyi for $45 USD.

Get free quotes for a project like this
Employer working
Awarded to:
Skills Required
Project Budget
$30 - $250 USD
Total Bids
Project Description

We need the code for an Excel Lookup Function to reference color codes on another database file. Example - the current field on File 1 has the values, “white”, “black”, “red”, etc. We want to be able to run the function so that these color codes lookup File 2 and output the corresponding numeric color codes (i.e. “10”, “20”, “30”, etc) to a separate field in File 1 . We need the output to be on one line, separated by commas, in one field.

We would also like the function to be able to lookup and output sizes from another file, similar to the above.

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