Having a drop down selection in one cell populate another cell with associated data

[bp32]

Hi:

I am trying to create a sheet where the user would select a client name from a drop down (say Company X) and then the selection of that company would populate another cell with a revenue value. The sheet would be pre-populated with the company and revenue data and a user need only know which company they want to check out to pull up revenue data. Can someone assist?

-BP32

 

[VoG]

Hello and welcome to MrExcel.

For the first cell you could use a data validation list http://www.contextures.com/xlDataVal01.html

For the second you could use VLOOKUP http://www.contextures.com/xlFunctions02.html

 

[bp32]

Brilliant! Worked perfectly, thanks so much!