Have a drop-down list retrieve data

Im building a sheet with a drop down list of the States.Done that part. When a State is selected, I want to have Data on that State appear in a box next to that drop down. I have already created additional sheets with the data in it. How can I get it to paste in that box on the main sheet?

Hi,

The VLOOKUP() function will solve your problem ...

HTH
Cheers
Carim

Originally Posted by Carim

Hi,

The VLOOKUP() function will solve your problem ...

HTH
Cheers
Carim

Carim,

Can you please let me know how V-lookup would solve this problem

Rgds
Humility