View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
T. Valko T. Valko is offline
external usenet poster
 
Posts: 15,768
Default 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.