String Manipulation?

Hello,

I'm having trouble getting my vlookup formula to work. Can someone help me?Attached is my workbook. I'm trying to get sheet1!B5 to pull from sheet2!B4.

I can't change sheet2 in any way because that is how I download it from a separate application.
I can only change what's in column B of sheet1.
Everytime I download sheet2, there's no telling in which rows the numbers will appear, so I can't put the formula "=sheet2!B4" inside cell sheet1!B5. A simple cell-to-cell link simply won't do.

There's an added complication because the string I'm looking up (sheet1!A5) is actually shown multiple times on sheet2 in nested phrases.

I'm sure it's simple, but I'm clueless.

Hi Sean,
your vlookup formula won't work because of the spaces in the other ranges, the trim function would be required to clean up the spaces

Hi Sean,
Here is a macro you can try

Please Login or Register  to view this content.