Forum Discussion
Complicated Excel Lookup Formula
Hello all, I'm hoping to get some help on a project I'm working on. In the simplest way put: I have an excel sheet containing a drop down list of types of retailers. For example, when you cli...
=INDEX(B1:B3,MATCH(D2,A1:A3,0))Maybe with this formula as shown in the attached file. You can apply VLOOKUP as well or XLOOKUP if you work with Office365 or 2021. The values in the INDEX and MATCH range A1:B3 are in white font color.