Finding data in one sheet and referencing it in another sheet.

Hi guys I need a bit of help. I have attached an example which should make the following a bit more clear..


If there is data in one of the 'day' cells in Sheet 1 then I need to find the next available day in Sheet 2 and then highlight it in Sheet 1. The box number (Column A in both sheets) is the reference point.

For example box 903 has Sat as one of its days in Sheet 1 (G3) so the next day on Sheet 2 is Sun (B25) so I would need the next Sun cell (H3) in Sheet 1 highlighting.

Another example would be 2794 again as Sat (G5) as one of its days. The next available day in Sheet 2 is Mon (B9) so I5 would need highlighting in Sheet 1.


It doesn't need highlighting with a color by the way, a letter 'x' will be fine.


Cheers guys

exxxxample.xlsx