Formula to look up from another tab

[Voodoo]

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.

 

[T. Valko]

One way:

=IF(ISNA(VLOOKUP(A1,Sheet2!A:B,2,0)),"",VLOOKUP(A1,Sheet2!A:B,2,0))

Copy down as needed.

 

[Shane Devenshire]

Hi,

=VLOOKUP(A1,Sheet2!A1100,2,False)

where A1 is the number you want to lookup in the first column of the range
on sheet2. The 2 indicates the column of the range A1100 that you want to
return the info from. And False says you are doing an exact match.

However, there is a problem with the fact that you may have more than one
match on the second sheet. This formula only finds one of those. You didn't
specify what you would do it there are two matches.

 

[Shane Devenshire]

Hi,

=VLOOKUP(A1,Sheet2!A1100,2,false)

this will pull the value from column 2 of the range A1100 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!A1100,2,false)),"",LOOKUP(A1,Sheet2!A1100,2,false))