using a description for a look up

houtaff

New Member
Joined
May 29, 2015
Messages
10
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

Does the VLOOKUP table have to be sorted?
No! when you are using an exact match, the VLOOKUP table can be in any order. Best-selling items at the top is actually the best.

Oeldere

Well-known Member
Joined
Dec 29, 2011
Messages
2,213
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

New Member
Joined
May 29, 2015
Messages
10
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
 

Watch MrExcel Video

Forum statistics

Threads
1,129,685
Messages
5,637,808
Members
416,983
Latest member
LessThanAverageUser

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.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

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

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

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
Top