Hi Everyone!
I am trying to work out the issue as below
I have in my
Columm A5:A3000 Column B5:B3000
Document Number Submittal Number
AA-544472-1 TR-0245
AB-611123-2 TR-0245
AB-321150-1 TR-0245
After typing in TR-0245 in Cell A1 in my other workbook (Transmittal), I need a result as below
Document Nos.
AA-544472-1
AB-611123-2
AB-321150-1
NOTE: That the Document Nos are in different Rows.
Appreciate in any help.
Thanks in advance,
Rev12
Bookmarks