Hi All
I have a spreadsheet where the first 2 columns are headed ID Number and Title, (Mr,Mrs,Miss)
Column B has a drop down validation list Mr,Mrs,Miss named Title
So when data is entered in Col B4 ie Mr, or Mrs, or Miss I want to reveal an ID number starting at Col A4 which is 926 and then so on down to Col B1004 and ID Number in Col A1004 which will be 1926
Any Ideas? I have tried hard with this

Many thanks
Bern