Forum Discussion

ToddFleming's avatar
ToddFleming
Copper Contributor
Aug 02, 2024

Vlookup, Index, Match

Excel idiot here..... In the pic below, on the sheet on the right, I am choosing two values in columns E and F from validation (reference the sheet on the left) and would like to return a value from...
excel
Patrick2788's avatar
Patrick2788
Silver Contributor
Aug 02, 2024

ToddFleming 

There's several ways to tackle this one. I prefer using 365 functions when possible so I'll offer XLOOKUP.

 

This solution presumes the lookup range is a table called Rates.

=XLOOKUP(
    I2,
    Rate[Position Code],
    XLOOKUP(
        J2,
        Rate[[#Headers],[Regular Rate]:[Emergency Rate]],
        Rate[[Regular Rate]:[Emergency Rate]]
    )
)

 

Resources