Hi, hoping you can help as I can't seem to work this one out. I have three sheets with various data which can occur anywhere in those three sheets. I get updated data every 2 days and need to check if there are any changes.
Data comes in in rows, but data in the three sheets are displayed in columns. eg comes in as 8123, abc, 08:15, but is displayed as
8123
abc
08:15
I need to find the 8123 (for example) which is column F in the data in the three sheets and return the two values below it. I can then conditional format to highlight any differences.
I have the formula below which does work, but only checks one sheet and one column and I need to check all three sheets for a match.
=INDEX('sheet1'!$F$1:$F$51,MATCH("F7,'sheet1'!$F$1:$F$51,0)+1,1)
Thank you
Data comes in in rows, but data in the three sheets are displayed in columns. eg comes in as 8123, abc, 08:15, but is displayed as
8123
abc
08:15
I need to find the 8123 (for example) which is column F in the data in the three sheets and return the two values below it. I can then conditional format to highlight any differences.
I have the formula below which does work, but only checks one sheet and one column and I need to check all three sheets for a match.
=INDEX('sheet1'!$F$1:$F$51,MATCH("F7,'sheet1'!$F$1:$F$51,0)+1,1)
Thank you