### [Solved] LOOKUP merged cells problem

Posted:

**Wed Jan 07, 2009 2:36 pm**Hi,

I'm having problem using the LOOKUP function in merged cells.

This is my problem:

A5 = Merged cell B5 and C5 (in my sheet A5 is "10 11 - 'some text'")

D5 = VLOOKUP($A5;Rawfile.$A$2:$P$382;4)

This return a value from another cell. I suppose this is because the function is reading the content of A1 wrong.

I've tried to "trim" the cell content but it doesn't remove all spaces - so the problem doesn't disappear

I've also tried to add a "_" instead of the space but it doesn't change anything either.

So, how can I make the LOOKUP function read the cell correctly?

Thanks for any suggestions

I'm having problem using the LOOKUP function in merged cells.

This is my problem:

A5 = Merged cell B5 and C5 (in my sheet A5 is "10 11 - 'some text'")

D5 = VLOOKUP($A5;Rawfile.$A$2:$P$382;4)

This return a value from another cell. I suppose this is because the function is reading the content of A1 wrong.

I've tried to "trim" the cell content but it doesn't remove all spaces - so the problem doesn't disappear

I've also tried to add a "_" instead of the space but it doesn't change anything either.

So, how can I make the LOOKUP function read the cell correctly?

Thanks for any suggestions