Hi,

=VLOOKUP(A1,Sheet2!A1:D100,2,false)

this will pull the value from column 2 of the range A1:D100 if A1 on sheet1
is found in column A of sheet2. Otherwise it will return NA, so show a blank
instead:

=IF(ISNA(VLOOKUP(A1,Sheet2!A1:D100,2,false)),"",LO OKUP(A1,Sheet2!A1:D100,2,false))


--
If this helps, please click the Yes button

Cheers,
Shane Devenshire


"Voodoo" wrote:

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.