# using a description for a look up

#### houtaff

##### New Member
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

### Excel Facts

What is =ROMAN(40) in Excel?
The Roman numeral for 40 is XL. Bill "MrExcel" Jelen's 40th book was called MrExcel XL.
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.

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

Replies
6
Views
2K
Replies
0
Views
595
Replies
29
Views
3K
Replies
7
Views
614
Replies
11
Views
1K

1,216,487
Messages
6,130,945
Members
449,608
Latest member
jacobmudombe

### We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.

### Which adblocker are you using?

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

### Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

### Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back