Thread: What is the syntax for referencing another sheet with 'lookup'
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Toppers Toppers is offline
external usenet poster
  
Posts: 4,339
Default What is the syntax for referencing another sheet with 'lookup'
Try, assuming A & B are on Sheet1:

=LOOKUP(1,Sheet1!A1:A5,Sheet1!B1:B5)

HTH

"ihenderson" wrote:

I am trying to reference a lookup table from another sheet - I have tried the
format
=lookup(sheet1!(1, a1:a5, b1:b5)) and other permutations - with & without
brackets - can you help? (I am using Excel 2003)
Thanks
Reply With QuoteReply With Quote