I need your help to find the correct values by formulas.
I have data in four Columns
Col A - Country Name
Col B - Vehicle Type
Col C - Price 1
Col D - Price 2
I have to 1st identify the Country Name (col A), then find out the correct "Price 2" value (col D) of a particular Vehicle Type (col B)
Now I have to identify/arrange the data from these columns to a new layout, where I know how to identify the results from col D.
I just apply the 1st filter on a Country Name (col A),
2nd filter on Vehicle Type (col B),
3rd filter on Price 2 (col D)
The attached file has the both the layouts... Please help me!
Thanks in advance!