M
Mekinnik
How can I use the data validation tool in a column on sheet1 based off of
data from sheet 2 a1-a50(I do know how to use the tool), where if you choose
say 'xx'(the value from a1) from the drop down list the function will return
the value from sheet2 b1 instead of a1.
data from sheet 2 a1-a50(I do know how to use the tool), where if you choose
say 'xx'(the value from a1) from the drop down list the function will return
the value from sheet2 b1 instead of a1.