View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Kerry Kerry is offline
external usenet poster
 
Posts: 72
Default 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