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

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


Reply With QuoteReply With Quote