create drop down box in cell

[excelgal]

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

 

[Anne Troy]

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
<-*-><-*-><-*-><-*-><-*-><-*-><-*-><-*->

 

[Frank Kabel]

Hi
see
http://www.contextures.com/xlDataVal01.html