Hi guys,

How would you make a formula that is dependent on the cell to the left of it?

Say A1 could be "cars," "trucks," and "motorcycles"

I want B1 to INDEX and MATCH in different locations depending if it is cars, trucks, or motorcycles.

would it be something like(in B1) IF(A1="cars",INDEX(...))? What do you put in for the false statement of the IF?

What is the maximum number of IF statements that you can have in one formula?

Thanks guys,

Jonathan