Using data from a table in other table

Question

By example

table1

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

Answer 1

Do a VLOOKUP

=VLOOKUP(B2,Sheet2!$A$2:$B$5,2, FALSE) Given your stated tables, assuming the first one is Sheet2 and your second is Sheet1.