I'm really new to Forums, but I'll try my best to explain my situation.

I have a spreadsheet with various forestry-related values that correspond to site visits. Column A is labeled "Site". Columns B-K are the values found at each site. So, each row is each site's data.

What I would like to be able to do is make this spreadsheet easier to use for my co-workers.

To do this--the way it looks in my brain anyway-- I would like to make a drop-down menu in the "Site" column (which I can do), but then have each site's values appear next to the corresponding site.

I've tried INDEX/MATCH, LOOKUP, all that, but I can't seem to make it work.

Any ideas or suggestions would be much appreciated. Let me know if I need to explain this further too...I know it's kind of vague.

Thanks