MS excel 2003 macro looped data lookup & return

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 example 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