vlookup or match formula help

[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

 

[Max]

In Sheet1,
In C2, copied down: =VLOOKUP(A2,Sheet2!A:B,2,0)
will return the amounts from Sheet2's col B
--
Max
Singapore
http://savefile.com/projects/236895
Downloads:17,400 Files:358 Subscribers:55
xdemechanik