LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
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

 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Excel 97 formula doesn't work in Excel 2003 [email protected] Excel Discussion (Misc queries) 2 April 4th 06 09:34 PM
Excel Lookup MATCH formula moglione1 Excel Discussion (Misc queries) 1 February 22nd 06 06:14 PM
Excel 2002 Lookup formula returning wrong results? Val Excel Worksheet Functions 1 November 18th 05 09:07 PM
Formula checking multiple worksheets sonic-the-mouse Excel Worksheet Functions 2 June 5th 05 07:48 PM
vba 97 excel lookup formula chief Excel Discussion (Misc queries) 1 May 26th 05 08:40 PM


All times are GMT +1. The time now is 01:17 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"