Snasui Excel Forum

Hi Dear,

I need your input how to find the first follow of people name and vaccine and return cell address as in color cells.

Best Wishes,

..

B8
=INDEX(B$1:B$5,MATCH(A8,$A$1:$A$5,0))

C8
=ADDRESS(MATCH(A8,$A$1:$A$5,0),MATCH("follow",INDEX($A$1:$F$5,MATCH(A8,$A$1:$A$5,0),0),0),4)

Norkaz

Thank you.it working