Select function with multiple conditions

Hello Gurus,

I am trying to use Select function with multiple conditions and it seems not to work.

This is the scenario:

On the columns I have 6 different service types (1 to 6) with prices for each one and on the rows I have the vehicles type (1 to 10). 

If I input service type #1 and vehicle type #5 it should show the price for that combination and so on with each different combination. How can I do it since the data to pull it is not in only one column? (I will call it dynamic depending on the combination requested) 

Will appreciate your support. 

0 5 2,406
5 REPLIES 5
Top Labels in this Space