Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
help with look up formula
Thorough solution:
http://www.cpearson.com/excel/TablesAndLookups.aspx Simple solution: http://www.contextures.com/xlFunctio...ml#IndexMatch2 HTH, Ryan--- -- Ryan--- If this information was helpful, please indicate this by clicking ''Yes''. "Bob Bob" wrote: I need a formula that can look up the correct price from a grid price chart on from worksheet2. worksheet2 is set up like this Column A is different Heights and Row 1 is different widths. 15 20 25 12' $1.00 $1.10 $1.30 16' $1.20 $1.30 $1.60 18' $1.40 $1.50 $1.90 So on worksheet 1 I want to enter in cell A1 the height 16' & in cell B1 the width 20" then have cell C1 equal the price in this case $1.30 Thank to all who help, FYI the price chart is about 15 rows by 15 columns |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
help with look up formula
Try this:
=VLOOKUP(A1,Sheet2!A1:D4,MATCH(B1,Sheet2!A1:D1,0), 0) -- Biff Microsoft Excel MVP "Bob Bob" wrote in message ... I need a formula that can look up the correct price from a grid price chart on from worksheet2. worksheet2 is set up like this Column A is different Heights and Row 1 is different widths. 15 20 25 12' $1.00 $1.10 $1.30 16' $1.20 $1.30 $1.60 18' $1.40 $1.50 $1.90 So on worksheet 1 I want to enter in cell A1 the height 16' & in cell B1 the width 20" then have cell C1 equal the price in this case $1.30 Thank to all who help, FYI the price chart is about 15 rows by 15 columns |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
help with look up formula
Also
http://j-walk.com/ss/excel/usertips/tip020.htm best wishes -- Bernard V Liengme Microsoft Excel MVP http://people.stfx.ca/bliengme remove caps from email "Bob Bob" wrote in message ... I need a formula that can look up the correct price from a grid price chart on from worksheet2. worksheet2 is set up like this Column A is different Heights and Row 1 is different widths. 15 20 25 12' $1.00 $1.10 $1.30 16' $1.20 $1.30 $1.60 18' $1.40 $1.50 $1.90 So on worksheet 1 I want to enter in cell A1 the height 16' & in cell B1 the width 20" then have cell C1 equal the price in this case $1.30 Thank to all who help, FYI the price chart is about 15 rows by 15 columns |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
help with look up formula
I need a formula that can look up the correct price from a grid price chart
on from worksheet2. worksheet2 is set up like this Column A is different Heights and Row 1 is different widths. 15 20 25 12' $1.00 $1.10 $1.30 16' $1.20 $1.30 $1.60 18' $1.40 $1.50 $1.90 So on worksheet 1 I want to enter in cell A1 the height 16' & in cell B1 the width 20" then have cell C1 equal the price in this case $1.30 Thank to all who help, FYI the price chart is about 15 rows by 15 columns |
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
help with look up formula
That is a good link Bernard. I keep forgetting about that one; should
bookmark it when I get home. Biff, thanks for all the help over the past couple years. Ryan--- -- Ryan--- If this information was helpful, please indicate this by clicking ''Yes''. "Bernard Liengme" wrote: Also http://j-walk.com/ss/excel/usertips/tip020.htm best wishes -- Bernard V Liengme Microsoft Excel MVP http://people.stfx.ca/bliengme remove caps from email "Bob Bob" wrote in message ... I need a formula that can look up the correct price from a grid price chart on from worksheet2. worksheet2 is set up like this Column A is different Heights and Row 1 is different widths. 15 20 25 12' $1.00 $1.10 $1.30 16' $1.20 $1.30 $1.60 18' $1.40 $1.50 $1.90 So on worksheet 1 I want to enter in cell A1 the height 16' & in cell B1 the width 20" then have cell C1 equal the price in this case $1.30 Thank to all who help, FYI the price chart is about 15 rows by 15 columns |
#6
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
help with look up formula
Thanks all the link was great I just had to change the range of teh formula
around to fit the table I have but it worked great "ryguy7272" wrote in message ... That is a good link Bernard. I keep forgetting about that one; should bookmark it when I get home. Biff, thanks for all the help over the past couple years. Ryan--- -- Ryan--- If this information was helpful, please indicate this by clicking ''Yes''. "Bernard Liengme" wrote: Also http://j-walk.com/ss/excel/usertips/tip020.htm best wishes -- Bernard V Liengme Microsoft Excel MVP http://people.stfx.ca/bliengme remove caps from email "Bob Bob" wrote in message ... I need a formula that can look up the correct price from a grid price chart on from worksheet2. worksheet2 is set up like this Column A is different Heights and Row 1 is different widths. 15 20 25 12' $1.00 $1.10 $1.30 16' $1.20 $1.30 $1.60 18' $1.40 $1.50 $1.90 So on worksheet 1 I want to enter in cell A1 the height 16' & in cell B1 the width 20" then have cell C1 equal the price in this case $1.30 Thank to all who help, FYI the price chart is about 15 rows by 15 columns |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|