H lookup problem part II

[mufan]

Hello,
I have attached a report with H lookup. C21, C23, C25 won't take the hlookup equation for some reason. Neither will M11, M12, or M13. Any idea why it works in I21, I23, and I25 but not in the previous mentioned cells?

thanks,
joe

[kersplash]

Looks like it's something to do with your merged cell in I7:N7. If you change the scope of Date to just I7 it works.

[protonLeah]

Your lookup named range DATE is in merged cells I7:N7. Unmerge the cells and use I7 only. For looks, just select I7:N7 and select center across selection.

[FlameRetired]

Same thought. This works because date is in first cell only.

Please Login or Register  to view this content.