ExcelBanter - Lookup in excel

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - Lookup in excel (https://www.excelbanter.com/excel-discussion-misc-queries/169082-lookup-excel.html)

joel

Lookup in excel

Hi I have a lookup formula which is below but I wish to change where it looks
I would like it to look in a diffrent sheet.

=LOOKUP(10^10,X21:X52) This is the formula but I would like it to look in
sheet3.

Thanks for your help joel
--
N/A

Bob Phillips

Lookup in excel

=LOOKUP(10^10,Sheet2!X21:X52)

--
---
HTH

Bob

(there's no email, no snail mail, but somewhere should be gmail in my addy)

"Joel" wrote in message
...
Hi I have a lookup formula which is below but I wish to change where it
looks
I would like it to look in a diffrent sheet.

=LOOKUP(10^10,X21:X52) This is the formula but I would like it to look in
sheet3.

Thanks for your help joel
--
N/A

Mike H

Lookup in excel

Perhaps

=LOOKUP(10^10,Sheet3!X21:X52)

Mike

"Joel" wrote:

Hi I have a lookup formula which is below but I wish to change where it looks
I would like it to look in a diffrent sheet.

=LOOKUP(10^10,X21:X52) This is the formula but I would like it to look in
sheet3.

Thanks for your help joel
--
N/A

All times are GMT +1. The time now is 08:48 AM.