Need to Look up a Value from another sheet

[nbeers]

Hello, i have excel 2010 and i need help with the formulas below

Price Book100.xlsx


i need the cell listed in O20 on the frameless shower door sheet to be display in K20 but i need it to display the cell from shower settings sheet

I need to be able to lookup another value on

Finish: Chrome QTY
Clamps: Squared 4

i have this layout here after qty i want it to return the value i have on a separate worksheet,

Hardware Type Chrome Brushed Nickel Oil Rubbed Brass
Squared $6.4700 $6.4700 $7.1500 $6.1300
Beveled $6.8500 $6.8500 $7.6000 $6.5300
Rounded $10.2100 $10.2100 $13.8100 $9.8400

i already have a nested if loop that returns the cell i want to show but i cant seem to figure out a formula that will work.
Ive tried using formulas like ( ='Shower Setting Sheet'!('Frameless Shower Doors'!P21) ) <-- this is what i need to do though!

Can anyone Help! Thanks

[wfm007]

If possible attach the both files

[ChemistB]

For pulling data from a table, INDEX/MATCH is a good tool.

http://www.contextures.com/xlFunctions03.html

=INDEX(Sheet1!$B$2:$E$4, MATCH(B2, Sheet1!$A$2:$A$4,0), MATCH(B1, Sheet1!$B$1:$E$1,0))
See attachment
Questions?

[nbeers]

im new to programing excel i really didnt understand our post!

[nbeers]

This is a great tool but it doesn't do what i need, i have 2 cells 1 returns a letter the other returns a number i use another cell to combine them and lookup that cell on the other sheet, but i need the answer to show up on sheet 1