Thanks for everyone's patience on this!

Here is a breakdown of the specific tasks that I need accomplished. I'm
uncertain now whether this is LOOKUP, VLOOKUP, MATCH, INDEX,
MATCH/INDEX or what.

1) Search Range A1:A6785 in Worksheet #1 for the matches in every cell
in Worksheet #2.

2) Find the corresponding adjacent text data in Range B1:B6785 in
Worksheet #1.

3) Copy the found text data from Range B1:B6785 in Worksheet #1

4) Paste found text date into new cells adjacent to matched cells in
Worksheet #2.

So, how do I do this?

Thanks!

Stephen