Position Salary Seller 150 Management 200 Technical 120 Maintenance 100
table2 (in same sheet or diferent, 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 colum??
I've already selected Data->Validation->List for Position in table2 but how can I fill the "salary" column automatically??
thank you for any help