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.
39 freelancers are bidding on average $64 for this job
Please see feedback on recent Excel Projects. I can do this today, Wed, in just a few hours. See example. Named colours by function or actual colors by macro. David
We are new in freelancer but we are 5 years experienced data entry [login to view URL] are sincerely read your requirements and are ready to endow with the solution as per your requirement.Thanks.