Do you mean "locate data from a cell in another column of data and when
found, return matching data from an adjacent column in the same row?"

If so, you can use LOOKUP if the data is ordered and sequential, or VLOOKUP
if it is not and the adjacent cells are to the right.

Best function is INDEX/MATCH because it will match anything and return data
from any direction.

--
"Actually, I *am* a rocket scientist." -- JB

Your feedback is appreciated, click YES if this post helped you.


"sfself" wrote:

I'm trying to find specific data in a cell and then display that data and its
colocated data in two adjoining cells in the same row.