Hi Vincent,

If I understand your description correctly, this frmula should do the
trick:

=INDEX(Sheet1!A:A,MATCH("Vendor *",Sheet1!A:A,0))

I hope that works,

Gary