Search Lookup query

[rajtak]

Hello Everyone,

Please refer to the sample spreadsheet below and let me know your suggestions.

https://skydrive.live.com/view.aspx?cid=3FD0284A9C0EDDF0&resid=3FD0284A9C0EDDF0!191&app=Excel&wdo=1

1) I want to search every part number listed in column C on Column A and pull the image file name wherever the part number exist within the name
2) Image file names are not exact match so a straight forward vlookup won't work here
3) It might also be possible that a same part number exist within multiple image file names, so the first occurrence of search must be pulled in Column D, 2nd occurrence in Column E and so on.

Thank you in advance for your help.


Regards,
Raj

 

[rajtak]

Azumi's formula pulls the exact match also

Hi Aladdin,

Why your formula doesn't work with exact match?

If I add '1011' (exact part number) in column A it should be shown in the output but it doesn't shows.

 

[Aladin Akyurek]

Azumi's formula pulls the exact match also

Hi Aladdin,

Why your formula doesn't work with exact match?

If I add '1011' (exact part number) in column A it should be shown in the output but it doesn't shows.

Not sure what you mean. If B3 is 1011, and there is a matching entry in column A, the match will succeed without any problem.