Inherited spreadsheet-can you check that the same entry is in the same cell in diff sheets

I have a workbook with 15 different sheets. The first sheet counts up various things from the other sheets- people are listed with amounts next to them. How can I check (not manually) that the same staff are listed on the same row on each sheet, so that the formulas are correct.

A quick check would be to see if you have used the same number of rows in each of those 15 sheets - if not then the names will clearly not be in the same place in every sheet.

You could also have a formula like this in the first sheet:

=A2=Sheet2!A2

assuming the names are in column A and start in cell A2. Copy this formula down, and it will result in either TRUE or FALSE - make any necessary corrections to Sheet2. Then change the formula to look at Sheet3, and again change Sheet3 if necessary. Repeat for the other sheets.

Another approach would be to use this formula:

=MATCH(A2,Sheet2!A:A,0)

and copy down. This will give you the row number where the name is found in Sheet2 (which should be the same as the row that the formula is on) or #N/A if the name is not found. Again, make corrections to Sheet2, then repeat the formula for Sheet3, and so on.

Hope this helps.

Pete

This site is amazing, thanks ever so much- its nice of you to take the time- Ill try these now.