Position Salary Seller 150 Management 200 Technical 120 Maintenance 100
table2 (in same sheet or in a different sheet that doesn't matter)
Name Position salary John Seller ? Paul Technical ? Julia Management ? Martha Seller ? George Technical ? Ringo Maintenance ?
How can I put the salary corresponding in third column?
I've already selected
Data->Validation->List for Position in
But how can I fill the "
salary" column automatically?
Thank you for any help.