Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Excel 97 formula doesn't work in Excel 2003 | Excel Discussion (Misc queries) | |||
Excel Lookup MATCH formula | Excel Discussion (Misc queries) | |||
Excel 2002 Lookup formula returning wrong results? | Excel Worksheet Functions | |||
Formula checking multiple worksheets | Excel Worksheet Functions | |||
vba 97 excel lookup formula | Excel Discussion (Misc queries) |