Hi Admin
This is the scenario
I have this table
Route Type Road_Air JAN FEB MAR APR MAY JUN JUL AUG 125 Liquid Road 12 12 12 12 12 12 12 12 125 Metal 13 13 13 13 13 13 13 13 125 Air 14 14 14 14 14 14 14 14
If My route no is 125 and Type is Liquid and Road_Air = Road, Display Jan Price
If my route no is 125 and Type is Metal, then display second priceline i.e Jan = 13
If my route is 125 and Road_Air = "Air", then display third priceline for Jan = 14
If my route is 125 and above all criteria doesn't meet, display 4th price for Jan.
Please help to code and get the price from the table.