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.