Drop Down List / Count Function

From: Mukiwa (Mukiwa.191ir1_at_excelforum-nospam.com)
Date: 07/07/04 

Date: Wed, 7 Jul 2004 15:17:27 -0500

Dear All

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

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

I'd be grateful for any advice.

Kind regards

Alex 

---
Message posted from http://www.ExcelForum.com/