Drop down list formula - help required

Hi peeps,

Need some help please!

I need to produce a formula and a single numeric result from a couple of drop down lists. The drop down list values are presented in text, but I require the formula in numerics. I am guessing that I will have to do this through VLOOKUP, but not too sure how to go about it.....

More details of what I need to do.......

I have two drop down boxes which have a text format selection (in black), but need to relate to a numeric value (in red):

FIRST DROP DOWN (the 'multiplier')

In Hours - 1
OOH (+ Sat) - 1.5
OOH (Sun + BH) - 2

SECOND DROP DOWN (the 'rate')

Labour 1 Man - 22
Labour Fitter + Mate - 66

In a spreadsheet, I need to multiply the chosen rate numeric value by the chosen multiplier numeric value and then, output this total numeric value to a cell on the worksheet.

Any help and/ or advice on how to do this would be appreciated.

Originally Posted by NBVC

Try:

=VLOOKUP(A1,{"In Hours",1.1;"OOH (+ Sat)",1.5;"OOH (Sun + BH)",2},2,0)*VLOOKUP(B1,{"Labour 1 Man",22;"Labour Fitter + Mate",66},2,0)

where A1 and B1 are drop downs, respectively.

A HUGE thanks - works like a charm and does what it says on the tin!! I think I was making things too complicated by my feeble attempt to 'script' it......