What is the syntax for referencing another sheet with 'lookup'

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
 
Try, assuming A & B are on Sheet1:

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

HTH
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Switch lookup function to another sheet 2
Scrabble Value calculation for Welsh words 0
Lookup Function Referencing cells, not text values 3
Vlookup with wildcard 2
Help with VLOOKUP & MATCH formula 5
LOOKUP function does not work with row vector of numbers 10
Multiple criteria LOOKUP 2
help with lookup please 1

Back
Top