Hi,

Why don't you show an example of the the data and result you want, because
if the data cells you are searching are on row 1 and you want the matching
data on row 2, you need a different formula than if the search cells are in
column B and the values you want returned are in column A. Also if you are
searching for the a cell containing the text X in a cell containing something
like ABXCD then the approach will be different. If you are trying for and
exact match or just an approximate match the technique will be different. If
you are trying to do a case sensitive search then yet different issues must
be handled.

You could use VLOOKUP, LOOKUP, HLOOKUP, MATCH with INDEX or OFFSET and
possibly many other approachs.

--
If this helps, please click the Yes button.

Cheers,
Shane Devenshire


"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.