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