alohamelinda
asked on
Excel 2013 Lookup results for a VLookup/HLookup table isn't working right?
So I have this table of data (my base price sheet) it's got 2 formulas Vlookup and Hlookup. The calculation or rather 'lookup' is producing the correct results with the input of sq.ft. and linear feet however when I go to my bid sheet, i don't know how to reproduce those results based on the input of sq. ft and linear feet on my bid sheet. It doesn't seem to want to look up anything for me? I've attached a sample of my bid sheet, the data set (table based on sq. ft & linear ft.) and the lookup to return the result. I just need help getting my results in the bid sheet?
Base-Price-Test.xlsx
Base-Price-Test.xlsx
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER