Excel Quote Setup

[Chloe_Seymour]

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 worksheet (I think). I want a set of codes with numerical values attached to them from which I can then enter those codes and it automatically assigns the numerical value to it in the next cell. 

So if I type BH50 into A1 I would like that to enter £200 into B1. A different text would need a different price, so BH60 (into e.g. A2) would enter £350 (into B2). But if I then changed A2 to BH50 then B2 should become £200. 

Am I using the wrong programme for this and if not, is it possible? 

Thank you! 

[#2]

@Chloe_Seymour 

=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.