Index Match or V Look up

[grcshekar]

Hello

In the attached sheet summary, I have formulas in columns C,D,E,F AND G which does not work if I move the rows in sheet attendance because am not matching Column A in both sheets and not checking entire range.

How to alter this to match Column A in both sheets and check entire range so I can get same results when I move the rows up or down in attendance sheet.

[JohnTopley]

Try

in D6

Please Login or Register  to view this content.

Change "WO" for other columns

[grcshekar]

But for Column C this does not seem to work

[JohnTopley]

Try

Please Login or Register  to view this content.