Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Peo Sjoblom
 
Posts: n/a
Default

One way

=INDEX($C$1:$C$13,MATCH(1,($A$1:$A$13=$F$1)*($B$1: $B$13=$G$1),0))

entered with ctrl + shift & enter



--
Regards,

Peo Sjoblom


"Columbo" wrote in message
...
I have a price list in excel that I print and give to my salesmen, right
now
they just look on the chart to get the prices. A2 thru A13 show the
height,
B1 thru T1 show the width and B2 thru T13 show the prices. I'd like to use
excel to enter a width in one cell and height in another to get the price
and
think I have to use < for the measurments in between. I have played
around
with this off & on and have realized I have no idea where to start. If you
have any ideas, please let me know.



Reply
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
Subtracting based on number of miles Ms Chewie Excel Discussion (Misc queries) 3 December 21st 04 05:35 AM
Dynamic Column VlookUps Based on Week Number TLK40us Excel Worksheet Functions 3 November 14th 04 03:33 PM
EZ Q 4 U: How do I change a number to text, based on the number UCD GRAD Excel Worksheet Functions 2 November 9th 04 09:05 PM
generate serial number john douglass Excel Worksheet Functions 0 November 5th 04 10:49 PM
returning a text cell based on a number cell Josh7777777 Excel Worksheet Functions 2 November 2nd 04 07:42 PM


All times are GMT +1. The time now is 07:09 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"