VLOOKUP error

[aaron81006]

Please help. I have been building this estimating spreadsheet and strugling with this last part til I can't stand it anymore. I"m sure it's an easy fix without the tunnelvision.

On the M & L sheet, at M7, I can't get the VLOOKUP to work. It references the materials and prices that are input in the table on the right but keeps giving me a #REF error. My other VLOOKUP works fine (it references another page that I deleted for size).

Please help.

Thanks a bunch
Aaron

[martindwilson]

defined name is wrong for SteelShapesList it needs to be
='M & L 1'!$T$9:$U$22 i.e the whole range so you get a column 2

[aaron81006]

I knew it would be something dumb. Too many hours looking at it. lol...
Thanks soo much for your help.

[TonyB51]

Hi,

It apprears that you have deleted a Sheet from your workbook.
The formula in Cell K7 on Sheet M & L 1 shows =VLOOKUP(H7,#REF!$B$6:$C$1191,2)
Reinstate the sheet and redo your vlookup in cell K7.

Cheers

Tony

[martindwilson]

what has that to do with M7

My other VLOOKUP works fine (it references another page that I deleted for size).

[aaron81006]

i'm trying to show it solved but don't know where to do that.