using a description for a look up

[houtaff]

morning all

I have a formula that im trying to work out based on a description which links to a monetary amount

the below is a table id like to use so that if somebody types in the description below (FIRST COLUMN), excel will automatically recognize that it has a value (2ND COLUMN) and insert this into a cell

FB 1600 REAR DRIVEN	$850.00
12P REAR DRIVEN	$850.00
12P TOP DRIVEN	$950.00
14P TOP DRIVEN	$1,150.00

<tbody>
</tbody>

Any help would be gratefully appreciated

 

[Oeldere]

Make a table like you did above (in e.g. e1:f4).

if you add the text in cell a1 (e.g. 12P TOP DRIVEN)

b1=Vlookup($a1,$e$1:$f$4,2,0) will give the result € 950.00

and drag the formula down.

 

[houtaff]

ok sorry as i was a little bit behind in my explanation.

What i am looking for is a formula that reads when i type the words "14P TOP DRIVEN" it recognizes that it should be $1,150.00 etc etc. I have a formula similar using a range feature that the system recognises that the figure is within a range and drops the rate tied to that range into a cell

I was hoping to use something similar that when my guys working offsite type in the word the cell recognises that it is a constant sum and inputs the charge

A bit like the below which is what im playing with right now

=LOOKUP(S2,{0,21,41,61,101,151,251,301,9999999},{2.99,2.67,2.41,1.97,1.61,1.49,1.41,1.33})

If i could somehow replace the left hand side with the "12P TOP DRIVEN and then the right hand portion of the above formula with the costs for the top drive etc this is what i need

Hope this makes sense