HLOOKUP on Two Ranges
Hi,
I would like a formula please. I have a table in cells c4:aa7. I want to lookup the value in cell B10 where the table array is in cells C4:AA5 and the row index number is 2. But I also want it to lookup the same cell B10 in C6:AA7 with the same row index 2 please. Thanks in Advance. All the Best. Paul |
HLOOKUP on Two Ranges
=IF(ISERROR(HLOOKUP(B10,C4:AA5,2,FALSE)),HLOOKUP(B 10,C6:AA7,2,FALSE),HLOOKUP(B10,C4:AA5,2,FALSE))
This formula will look at both ranges at the same time, -- If this posting was helpful, please click on the Yes button. Regards, Michael Arch. "Paul Black" wrote: Hi, I would like a formula please. I have a table in cells c4:aa7. I want to lookup the value in cell B10 where the table array is in cells C4:AA5 and the row index number is 2. But I also want it to lookup the same cell B10 in C6:AA7 with the same row index 2 please. Thanks in Advance. All the Best. Paul |
All times are GMT +1. The time now is 12:23 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com