Data Validation - Lists

[Darth_Williams]

Good afternoon all,

I am looking to to list data validation over different columns but have it so that the selection in the first column will only show a certain selection in the second.

So column A will show a certain supplier then column B will only show what that supplier provides, Column C will show the unit price for the result of column B. I'm guessing that this last part would be best achieved with a VLOOKUP but I am open to suggestions.

Any help or advice will be gratefully received.

Thanks

 

[MARK858]

It seems like you mean dependent dropdowns, see if the link below is what you are looking for...

https://contextures.com/xlDataVal02.html

 

[Darth_Williams]

This is exactly what I was meaning. Thank you very much Mark