I am attempting to us a vlookup formula and quite frankly struggling.
I have a sheet labeled Control and I have Cell D7 that selects from a Cell Validation dropdown list frome sheet2 (list)
On sheet2(list) i have a small sample of data.
My desire is to select on CONTROL sheet D7 and have the corresponding Name on LIST sheet populate.
Is Vlookup the proper way to tackle this problem?
Additionally, can you have an Cell Validation Autofill? I cannot find anything that allows this ability.
Thanks and appreciate the consideration attached is a simple example