Vlookup New Table

kcdill · Oct 24, 2007

I have a Workbook for material takeoffs and another Workbook for all my lookup Tables.
I have added a new table of Square Tubes to my tables workbook. I am using the following formula to lookup values in the new table. =IF(ISNA(MATCH(C100,'BT_Blank Master.xls'!SqRect_LBL,0)),"BOGUS","SqTube") to identify the product as a Square Tube. However the formula returns BOGUS as the identifier in stead of SqTube.
And the following formula =IF(E100="SqTube",VLOOKUP(C100,'BT_Blank Master.xls'!SqRect_TBL,3)*G100,"BOGUS") to calculate the piece weight. This formula returns BOGUS in every cell that is supposed to display the weight. The formula can't seem to find the Square Tube table.
I have been using the following formula for the pipe table for several years without incident. =IF(ISNA(MATCH(C102,'BT_Blank Master.xls'!PIPE_LBL,0)),"BOGUS","PIPE") so I copied it and changed the names for the new Square Tube table.
The new Square Tube table is on the same worksheet as the Pipe table.
How can I get the Square Tube formulas to find the Square Tube table? Thanks for your help.

R-D · Oct 24, 2007

Can you post some sample data/information? Just guessing but it seems PIPE_LBL may be a named reference to your table? This is different from the worksheet name. Have you created a named reference for your new table?

kcdill · Oct 24, 2007

Good Afternoon R-D:
All of the tables are on a worksheet named TBL_PIPE.
There are six tables on the TBL_PIPE worksheet named as follows:
ELL_LBL and ELL_TBL.
FLG_LBL and FLG_TBL.
PIPE_LBL and PIPE_TBL.
REPAD_LBL and REPAD_TBL.
SH_NOZ_LBL and SH_NOZ_TBL.
and the new table SqRect_LBL and SqRect_TBL.
The respective lookup formulas are all working fine and finding the LBL and TBL values on the TBL_PIPE worksheet. Except for the new SqRect table which can't seem to find the SqRect_LBL and SqRect_TBL.
I am working on sending you some cells from the Takeoff worksheet and the TBL_PIPE worksheet.
Regards,