Search a column for content equal to a cell and return cell value adjacent

[ninsianna]

Not sure I described that well, but here's my example:

I have this cross referenced code and reference numbers:

Code	Ref numbers
OQ COR 01	7, 7.1, 7.2, 7.3, 7.4, 7.5, 7.7
OQ COR 02	5.2, 7.6, 13, 13.1, 13.2, 13.3, 13.4, 13.5,
OQ COR 03	10, 10.1, 10.2, 11
OQ COR 04	8, 8.1, 8.3, 12,
OQ COR 05	5, 5.1, 5.2,5.3, 8, 8.1, 8.3,

<tbody>
</tbody>

I have a list of reference numbers:

Ref #

4.3 5.1 5.2 5.3 7.1 7.2 7.3 7.4 7.5 <tbody> </tbody>

<tbody>
</tbody>

I would like to search the Ref numbers to see if the Ref # is included, and if so, return the contents of the adjacent cell.

So : if the contents of C1 are included in column Y, in cell Y3, then return the contents of X3

The biggest issue is of course that the contents in column Y include multiple reference #s, so I'm not looking for an exact match. Even if I split them into individual columns, I'm not getting an accurate result with lookup or vlookup

 

[markmzz]

That did not work for me. It returned blank data.

Try to change the , to ;

Like this:

=IFERROR(INDEX($A$2:$A$4;MATCH($D2;$B$2:$B$4;0));"")

Did you try with exact my layout? If not, could post your layout?

Could you post the exact formula that you used too?

Markmzz