Search for text in 1 column and return text from another

[madadd]

Hello,

So I've got col. A and B. I want to search the text in A, but without the last 5 char. in Col. B. Here's that code which works fine.

Please Login or Register  to view this content.

But now instead of displaying an X, I want to pull the last 5 characters from column B for which the code above would have normally put an X.

So, Conceptually I have this which doesn't work.

Please Login or Register  to view this content.

[NBVC]

Is there only one match? or are you expecting multiple returns from column B?

[madadd]

Oh, um there might be more than one, but I really only need one. Honestly whichever is easiest to do.

[NBVC]

This would return the 1st match it comes across, if any:

Please Login or Register  to view this content.

[madadd]

Ah sweet, you're awesome. Thank you very much!