Using Index and Match to bring back first blank in column

[jjmarquez89]

Good afternoon,

Here is the pickle I'm in. Working on applicant tracking report. Trying to automate as much as possible. I'm bring information from 1 sheet to another so things won't have to be imputed twice.

Currently using Index and Match to look at the job number to bring over the offer date a candidate was extended. As you can see were multiple candidates submitted for Job ID 10953 but when I run Index and match to get the information over to Sheet 2 it brings blank. Open to any ideas on how to go about this.

Current formula I am using: =index('sheet1'!$S:S,match($C2,'Sheet2'!$A:$A,0))

 

[maabadi]

Try this:

=INDEX('sheet1'!$S:S,MATCH(1,INDEX(('Sheet2'!$A:$A=$C2)*('sheet1'!$S:S<>""),0),0))

 

[jjmarquez89]

=INDEX('sheet1'!$S:S,MATCH(1,INDEX(('Sheet2'!$A:$A=$C2)*('sheet1'!$S:S<>""),0),0))

Thank you I'll give it a try