CODEWITHSUNDEEP
excel-formula
Ginny Pearson
Ginny Pearson

Reputation: 1

Microsoft Excel Multiple Worksheets and Data

I have two spreadsheets built. I want to be able to put what step a teacher is in which looks like this; BS, 1 or BS, 2 etc. (My second worksheet has each step and salary on it) I then would like the cell directly next to it to pull the correct salary amount from my other Worksheet.

I would add a picture, however it won't let me. Thank you for any help you can offer me.

Upvotes: 0

Views: 15

Answers (1)

Forward Ed
Forward Ed

Reputation: 9874

Assuming the name of the teacher and category of the teacher is in Sheet1 columns A and B

(A)      |   (B)
         |   
Max      |    1
Tammy    |    4
Alex     |    2

and on Sheet 2 you have category and salary

(A)      |   (B)
         |    
1        |     30000
2        |     45000
3        |     75000
4        |    120000

Then in cell C1 on sheet 1 you would use the formula:

=VLOOKUP($B1,'Sheet2!$A$1:$B$4,2,0)

You would then copy this formula down as required.

Alternatively you could achieve the same results with an INDEX/MATCH combination

=INDEX('Sheet2'!$B$1:$B$4,MATCH(B1,'Sheet2'!$A1:$A$2),0)

Upvotes: 1

Related Questions