Thread: Query to Return Value from Seperate Worksheet
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming,microsoft.public.excel.misc
vezerid vezerid is offline
external usenet poster
  
Posts: 751
Default Query to Return Value from Seperate Worksheet
Sean,
use VLOOKUP. In Worksheet1!B2:

=VLOOKUP(A2,'Worksheet2'!A:B,2,FALSE)

HTH
Kostis Vezerides

Reply With QuoteReply With Quote