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

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

Many thanks - quite obvious when you know how!

"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

..... so true! But I have been there too....

"ihenderson" wrote:

> Many thanks - quite obvious when you know how!
>
> "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