Excel Question

Question

Hello,

I have an Excel Form that has multiple Sheets. I an trying to have a Sheet named "SenList Feeder" contain information. and a Sheet named "Seniority List" that gets it's info from SenList Feeder. SenList Feeder contains names and info for employees. So the cells in the first Row of Seniority List are as follows:

A1: =IF(ISBLANK('SenList Feeder'!A1),"        ", INDEX('SenList Feeder'!A1:F499,1,1))

A2: =IF(ISBLANK('SenList Feeder'!A1),"        ", INDEX('SenList Feeder'!A1:F499,1,2))

A3: =IF(ISBLANK('SenList Feeder'!A1),"        ", INDEX('SenList Feeder'!A1:F499,1,3))

A4: =IF(ISBLANK('SenList Feeder'!A1),"        ", INDEX('SenList Feeder'!A1:F499,1,4))

A5: =IF(ISBLANK('SenList Feeder'!A1),"        ", INDEX('SenList Feeder'!A1:F499,1,5))

The problem is, if I delete a Row from SenList Feeder, the indexing in Seniority List gets messed up.

Any idea why?

Thanks,

Joe P.

Answer 1

Hello,

Thank You Andreas Killer, I looked at the link you posted.I have been tinkering with these for quite a while and I can't seem to get it to sort without jumbling. Any other ideas?

I have my info in "Sheet 2" and I'm copying it to "Sheet 1"

In "Sheet 1" I have these formulas:

A2- VLOOKUP(Sheet 2::Table 1::A2,Sheet 2::Table 1::A2:E7,1,FALSE)

B2- INDEX(Sheet 2::Table 1::$A2:$E11, MATCH(Sheet 2::Table 1::$A2,Sheet 2::Table 1::A2:A11),2)

C2- INDEX(Sheet 2::Table 1::$A2:$E11, MATCH(Sheet 2::Table 1::$A2,Sheet 2::Table 1::A2:A11),3)

D2- INDEX(Sheet 2::Table 1::$A2:$E11, MATCH(Sheet 2::Table 1::$A2,Sheet 2::Table 1::A2:A11),4)

E2- INDEX(Sheet 2::Table 1::$A2:$E11, MATCH(Sheet 2::Table 1::$A2,Sheet 2::Table 1::A2:A11),5)

Am I using the wrong combination of formulas? Or Wrong Syntax? Any help would be greatly appreciated...

Answer 2

Please have a look into this article:

Formula - How to pull data from another sheet without getting mixed up - Microsoft Community

Andreas.