Forum Discussion
Drop Down List - Linking Corresponding Data in Separate Columns Based on Drop Down Selection
Hey there! I'm looking for a clear cut way to do something which seems like it should be simple. I have two columns that I want to correspond with one another. What I'm looking to do is when someone ...
Just thought, you may want to use it with a IF function in case there is nothing selected in the Sales Status column, i.e. =IF(D6="","",VLOOKUP(D6,StatusTable,2))