[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