Hi roderh,
As Paul already said, it's far from a simple problem. The easiest way is to write a simple macro to solve the problem.
But i cannot help myself to choose the hard way, to find a formula that can do this.
Here it is:
=IFERROR(SMALL(IFERROR(IF(FIND($A$17;($B$2:$B$12&$ C$2:$C$12&$D$2:$D$12))>0;ROW($A$1:$A$11);"");"");C OLUMN()-1);"")
It's an array formula, so you have to confirm it with Ctrl+Shift+Enter, not with simple Enter after you type it.
Same formula is in sample workbook attached.
Wellcome to our forum
Tip: It's a very good idea to upload a sample workbook yourself to ease our efforts to help you, this time i wasted some time to transfer your data to excel, but usually, it's your obligation.
Cheers,
Catalin

Attached Files

tmp1321.xlsx (9.5 KB, 10 views)