Lookup formula in excel
Adding to Barb's response you could use the following in your cell:
=INDIRECT("_"& F2 & " " & F1)
Where F2 = weight (15Kg)
F1= country (France)
HTH
"Barb Reinhardt" wrote:
I saw something on how to do this not long ago in "This isn't Excel, it's
Magic"
I'm assuming you have your data in cells A1 to D5 for this example
Select B1 (UK) to D5 (16.5)
Insert - Name - Create
Select Top Row
Now select A2 (5kg) to D5 (16.5)
Insert - Name - Create
Select LEFT column
To find the intersection enter
=_15kg France
The _15kg and France will be named ranges.
"Kerry" wrote:
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
|