Conditional format based on another cell on another page

Closed
terrist Posts 1 Registration date Tuesday 3 June 2014 Status Member Last seen 3 June 2014 - 3 Jun 2014 à 15:55
venkat1926 Posts 1863 Registration date Sunday 14 June 2009 Status Contributor Last seen 7 August 2021 - 4 Jun 2014 à 07:38
I have two databases. One is a list of parents and the other a list of students. The parents each have a unique 'Parent ID.' I need to evaluate each student last name on one page and see if it matches a parent last name on the other page. If it does, I need the student to get the same, unique 'Parent ID.'

Any ideas? Thanks!

1 response

venkat1926 Posts 1863 Registration date Sunday 14 June 2009 Status Contributor Last seen 7 August 2021 811
4 Jun 2014 à 07:38
CAN YOU PLEASE POST A EXTRACT OF TWO SHEETS FIVE ROWS EACH