Reverse Lookup - 6 Alternatives

Download working file👈👨‍💻

Here I will be demonstrating 6 formulas / combinations through which we can apply reverse lookup. We all know that VLOOKUP has a limitation that it only works from Left to right. So in case of applying a reverse lookup, any of the below 6 alternatives can be used:

Alternative 1:

Using XLOOKUP

Alternative 2:

Using INDEX-MATCH

Alternative 3:

Using FILTER

Alternative 4:

Using VLOOKUP with IF

Alternative 5:

Using VLOOKUP with CHOOSE

Alternative 6:

Using TEXTJOIN and IF

Download working file👈👨‍💻

Thank You!