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

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

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

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

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

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