create drop down box in cell

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I would like to be able to create a drop down box in a cell with a list of contractors. And then
depending on which contractor is chosen, to have their labor rate automatically displayed in an
adjacent cell. Does anyone know if this is possible and how to do this?

Thanks
 
Hi, gal. You'll want Data Validation for the dropdown, and Vlookup to find
the contractor's rate. Explanations and free downloads for both of these
features is available at www.theofficeexperts.com/excel.htm

Good luck!

<-*-><-*-><-*-><-*-><-*-><-*-><-*-><-*->
Hope this helps!
Anne Troy (better known as Dreamboat)
Author: Dreamboat on Word
Email: Dreamboat*at*Piersontech.com
Web: www.TheOfficeExperts.com
<-*-><-*-><-*-><-*-><-*-><-*-><-*-><-*->
 
Back
Top