Multiple IF conditions...or is there a better way?

[mthelm85]

I have a workbook that contains 21 worksheets (tabs). The tabs are E1 - E20 and each one corresponds to an employee. The last tab is an employee key. The key contains a column with the employee name and then the worksheet number (E1, E2, whichever) that corresponds. I use the sort tool to put them all in alphabetical order and then I create a third column which is A1 - A20. I need a formula that I can place in the bottom right corner of each worksheet that will automatically place the corresponding A value (A1, A2, whichever) in that cell so that when I print out the workbook the A value is already there. It's basically like this:

Burton E3 A1
Dickerson E6 A2
Johnson E4 A3

So I need to place a formula on each worksheet that will automatically input the corresponding A value. I thought I could just use if and go down the line, if cell B2=E3, then the value should be whatever the adjacen cell is (in this case A1).

Does that make sense?

[roki4]

Can you attach a sample/dummy worksheet?

[Richard Buttrey]

Hi,

I find it difficult to visualise and understand what you're getting at.
Would you upload the workbook and manually add the results you expect to see and some notes explaining the result values.