Thread: What is the syntax for referencing another sheet with 'lookup'
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
ihenderson ihenderson is offline
external usenet poster
  
Posts: 2
Default What is the syntax for referencing another sheet with 'lookup'
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