If Then Formula

B

Bo

I am using Excel 2003 and am trying to make the following happen. I have
created a drop down list (using Data Validation) that consists of different
Labor Types. In another cell I have a place for Labor Rates. What I would
like to happen is upon selecting a Labor Type such as Project Manager the
cell would then automatically be populated with the associated Labor Rate.
Currently the source information is located in hidden columns in the
worksheet. I have 100 different Labor Types and associated Labor Rates. I
hope this makes sense. Any help is appreciated.
 
G

Gord Dibben

Bo

Select a cell in which the Rate is to be returned.

Enter =VLOOKUP(cellref,mylist,2,FALSE)

Where cellref is the DV cell and mylist is a named range of your two
column(Type and Rate)source information.

Gord Dibben Excel MVP
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Data question 1
Using Microsoft Access as a Service Ticket Write-up program 0
How to track labor cost comsumption against budget task 5
can you look up info from a validated drop down menu in excel 2007 1
Creating Summary Reports from Two Tables 2
total Amt Due, Taxes, Shipping, Expense and Total Amt Due on Invoi 2
Repeating Table and Looking up Values from a Sharepoint List 0
Case Statements 0

Top