You have chosen to sponsor your bid up to a maximum amount of .
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.