Lookup formula in excel
I have a spreadsheet of data set up in excel something like this
UK France Spain
5kg 5.00 10.00 15.00
10kg 6.00 12.00 16.00
15kg 7.00 13.00 16.25
20kg 8.00 15.00 16.50
I want to be able to type in a cell the county name and then in another cell
the weight, and then create a formaula which gives me the price from the
table above.
ie if i want france at 15kg... then the answer would be 13.00
Is this possible? any help would be really appreciated
|