Take the 2-minute tour ×
Super User is a question and answer site for computer enthusiasts and power users. It's 100% free, no registration required.

By example


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

share|improve this question

1 Answer 1

up vote 4 down vote accepted


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

share|improve this answer
+1 @JNK Thank you very much! (couldn't give you the +1, still have less than 15 reputation) –  Hernán Eche Sep 7 '10 at 20:03

Your Answer


By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.