| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| how copy formula that contains ranges so ranges do not overlap | Excel Worksheet Functions | |||
| union of named ranges based only on the names of those ranges | Excel Programming | |||
| Copy data in named ranges to a newer version of the same template to identical ranges | Excel Programming | |||
| hlookup via vba | Excel Programming | |||
| named ranges - changing ranges with month selected | Excel Programming | |||
Linear Mode
