vlookup or match formula help

W

Will123

i am trying to match, or line up identical ID#'s in wksheet 1 - column A
(which has 305 lines/rows) to ID#'s in wksheet 2 - column A (which has 9500
lines/rows). (also, each wksheet has a column B with misc $ amts). thanks
 
Top