Thread: Lookup from other sheet
View Single Post
  #7   Report Post  
Posted to microsoft.public.excel.misc
Paul Lautman
 
Posts: n/a
Default Lookup from other sheet
Paul Lautman wrote:
Pivotrend wrote:
didnt work

Try A2: =VLOOKUP(A1,Sheet2!$A$1:$B$5,2,FALSE)
instead

Actually make that

A2: =VLOOKUP(A1,Sheet2!$A$1:$B$6,2,FALSE)


Reply With QuoteReply With Quote