IF dependent INDEX MATCH

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

Maybe something like this

=INDEX(L1:N20,0,MATCH(A1,{"cars","Boats","planes"},0))