Drop Down List / Count Function

[Mukiwa]

Dear All

I'd be very grateful for some advice please. What I'm trying to do i
provide a project quotation, in column a, I have the name of the huma
resource, in column b, the number of days required of the individual'
time and in column c, the financial cost which is column a multipled b
column b basically.

I want to be able to use the look up name of the resource and attach
value i.e. Technical Director = £720. This is the day rate an
multiplied by the number of days in column b, will give a cost i
column c. Due to the fact that there are 30 people involved coverin
different functions, I want to be able to choose their names from
drop down list instead of typing a value and requiring the inclusion o
an additional column. So, the name chosen from the drop down list i
effectively an alias to a value in another worksheet. I created th
drop down list with no problem but I'm having trouble understandin
which function will automatically lookup the value from the array i
the other worksheet of the workbook. I don't know if it's match o
vlookup or if I'm even on the right track.

I'd be grateful for any advice.

Kind regards



Ale

 

[Jason Morin]

Assuming:

*A1: Drop-down list
*Sheet2, column A: resource titles
*Sheet2, column B: day rate in £

Use:

=VLOOKUP(A1,Sheet2!A:B,2,0)

HTH
Jason
Atlanta, GA

 

[Mukiwa]

Jason, thanks very much. That's perfect.