Drop Down List

[robertguy]

Hi,

can any please advise me how I would create a drop down list which I could select (say in Column A) a job tile e.g. Labourer, Plaster, which would then select their relevant hourly rate and display in the corresponding cell i.e. Column B.

Example Data (to be kept on a separate tab)

Labourer - £25.00

Plaster - £43.00

Electrician - £51.99

Foreman - £22.50


Any assistance would be greatly appreciated


Many thanks in advance


Rob

N.B. Excel version 2003

[dogberry]

Hi

Set your trade and prices up as a range then use the vlookuo function to put the rates in syntax vlookup(value you are looking for ie"Electrician",range the trades and prices,column2,false). If unsure upload a sample sheet.


Chris

[mrice]

Please see the attached.

It uses data validation to create the drop down and the VLOOKUP function to pull back the appropriate rate.

[Ace_XL]

Try something on these lines..

=INDEX(Sheet2!$B$1:$B$4,MATCH(A1,Sheet2!$A$1:$A$4,0))

where
- A1 is the cell with the dropdown
- Sheet2 A1:B4 contains your list with corresponding rates