Thread: Need help with Lookup
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
excelent excelent is offline
external usenet poster
  
Posts: 695
Default Need help with Lookup
Put in and copy down

E1=IF(A1=Sheet2!A1,VLOOKUP(A1,Sheet2!A1:G100,5,FAL SE),"")
F1=IF(A1=Sheet2!A1,VLOOKUP(A1,Sheet2!A1:G100,6,FAL SE),"")
G1=IF(A1=Sheet2!A1,VLOOKUP(A1,Sheet2!A1:G100,7,FAL SE),"")


Reply With QuoteReply With Quote