Hi,
If your ID column is the first column in your data sets then you can
use a VLOOKUP, if not then use a combination of INDEX and MATCH.
Say your ID #'s are in column A on the main sheet and your ID #'s in
column A and annual spend data in column B of sheet 2 then:
=VLOOKUP(A1,Sheet2!A1:B10,2,0)
If your annual spend is in say column A and your ID #'s in column B
then:
=INDEX(Sheet2!A1:A10,MATCH(A1,Sheet2!B1:B10,0))
Hope this helps!
JG
--
pinmaster
------------------------------------------------------------------------
pinmaster's Profile:
http://www.excelforum.com/member.php...fo&userid=6261
View this thread:
http://www.excelforum.com/showthread...hreadid=474578