Formula to look up from another tab
One way:
=IF(ISNA(VLOOKUP(A1,Sheet2!A:B,2,0)),"",VLOOKUP(A1 ,Sheet2!A:B,2,0))
Copy down as needed.
--
Biff
Microsoft Excel MVP
"Voodoo" wrote in message
...
Sheets 1 and 2 both have columns that have unique customer I.D.#s.
Sheet 2 does not have ALL unique customer I.D. #s but Sheet 1 does.
Sheet 2 has another column with a numeric value that I want to pull to
sheet
one for each unique customer I.D.
So....I need something to say if this ID# is found in this range of ID#s
in
sheet two then put the value of in the cell next to the ID# in sheet 2
into
this cell in sheet 1.
|