Using the lookup formula but is not working correctly

[susiesc]

I amd trying to enter a formula that uses a table lookup in the product pricing table based on the value selecyed in the column. And I am to add the IFERROR to it so the error message will come out blank. I am getting an error message #VALUE; what am I doing wrong?


=IFERROR(LOOKUP("Product Pricing and Shipping",B3:B17,FALSE)

and tried this one also without the IFERROR and it still does not work. =LOOKUP("Product Pricing and Shipping",B3:B17,FALSE)

Hmm....

[Pepe Le Mokko]

Do you mean

Please Login or Register  to view this content.

[susiesc]

Yes that is what I need but I wanted to have the cells blank instead of pulling over the amounts.

[FDibbins]

This is the same formula, but in a more-readable format...
=IFERROR(VLOOKUP(C16,'Product Pricing and Shipping'!$A$3:$B$17,2,FALSE),"")