Hello
I am trying to get a formula to help people know a price for a specific car service. Variables are selected from a list.
For example - the variables in the list in A2 are TEXT: Car 1, Car 2, Car 3
Variables in B2 are TEXT: Pre March 2013 and Post March 2013
Variables in C2 are TEXT: Year 1, Year 2, Year 3, Year 4
Basically I want to be able to pull from a hidden sheet the price that relates to any combination of the above
EG Sheet 1 A2=Car2 / B2=Pre March / 2013 C2=Year3 ...... returns data from Sheet 2 cell 3 which is a price.
Bookmarks