Greetings Esteemed Excel Wizards,
Attached is a workbook called "VLOOKUP or INDEX-MATCH + INDIRECT with Nested IF-OR Statement.xlsx" that I'm hoping you'll take a look at and maybe help me solve a problem that has me stumped.
I am attempting to use one formula to do the following:
Match any time interval values shown in the Time Intervals column on the "EARLIEST TIME NEEDED" sheet with the corresponding value found in the BIA RTO column of the "Account Services" sheet, then return the value from the BIA RTO column that matches the first Time Intervals value (in sequential order, beginning with "<= 1 HR" and ending with "<= 30 D").
In other words, given the following time intervals...
<= 1 HR
<= 24 HR
<= 72 HR
<= 1 WK
<= 2 WK
<= 3 WK
<= 30 D
... if "<= 72 HR" is the first time interval with a corresponding match in the BIA RTO column on the "Account Services" sheet, the formula would return that value ("<= 72 HR").
My hope is this formula will also:
- Match column headers found on each sheet.
- Use the INDIRECT to search the appropriate worksheet as the formula is copied down.
So far, I've only been able to come up with a fairly modest VLOOKUP formula that only matches the first time interval shown on the "EARLIEST TIME NEEDED" sheet with its corresponding value on the "Account Services" sheet:
If that time interval is not found, it simply returns an error. I have not been able to figure out how to expand the formula so that it proceeds to search for the next time interval value if the first is not found, etc.HTML Code:
Bookmarks