Forum Discussion
Chloe_Seymour
Jan 31, 2023Copper Contributor
Excel Quote Setup
Hello, I'm a very basic Excel user and I'm trying to set up a way to use it to create a costing/quoting sheet for myself. Basically I need the text in A1 to enter a price into B1, from a second w...
OliverScheurich
Jan 31, 2023Gold Contributor
=IFERROR(VLOOKUP(A1,$G$3:$H$11,2,FALSE),"")
You can set up a reference table and then apply this formula to look up the numerical value. If the code isn't found in the reference table an empty cell is returned by IFERROR.