Hello from Steved

=INDEX(ParadoxBusType!I:I,MATCH($A6,ParadoxBusType!$K:$K,0))

Ok the above formula at cell A6, then looks in Col I:I in ParadoxBusType!
worksheet
once found looks in K:K for the value, it is not working
please what have I overlooked. the formula is in Cell D6.

The above is in the same folder instead of sheet1 I've named it
ParadoxBusType!.

Thankyou for taking time on my problem.