Need a simply macro to look up data from 1 worksheet looking into another sheet and bring the find back into the 1. sheet and put the data back next to it
look into sheet "Running_Ads_Currently" and get the value from "b1"
look up that value in sheet"CategoryIDs-Motors" under Column "A" and if found return the value next to it from Column "B"
if the value is not found ensure that the macro does not crash or stop, you must create an error code for that within macro (can be simply to go the next line or reach the end of the sheet)
The repeat to the next row "Running_Ads_Currently" until the end of the sheet ( no value after the last entry)
see the desired results in worksheet "Running_Ads_Currently", cell c1 & c2
create the macro and attached in within the workbook called "eB data find1"
see attached MS Excel 2003 workbook
Hello. I will finish this very easy project for you in the blink of an eye. I will create error catching as you asked for, and fully comment out the code for inspection. Regards.