Trying to find the value from Table1ColumnB from the ranges in Table2ColumnB,Table2ColumnC, by first matching the values from Column A.
Table 1
A B Result (what I need) 1 120 boop 3 140 blam 4 220 beep 1 190 boop
Table 2 (lookup table)
A B C Return (what I want to extract) 1 100 200 boop 2 200 300 bap 3 100 200 blam 4 200 300 beep
Any help is greatly appreciated.
I've tried running an xlookup within an if statement, but finding it difficult to match it up.
APOLOGIES:
This was resolved using the formula presented by Pete_UK in the post: "Lookup Formula Based on Range" by XCEL123
=INDEX($D$2:$D$6,MATCH(1,(F2=$A$2:$A$6)*(G2>=$B$2:$B$6)*(G2<$C$2:$C$6),0))
Bookmarks