Indirect Function...

[Snowmonster]

http://www.mrexcel.com/forum/excel-q...ml#post3690897

Good morning everyone...

I have a Indirect function on my spreadsheet, it correctly selects the right information for everything in the source cell, apart from one, the word Nursling...

I have checked that everything is alphabetical, but I don't think that matters, the formatting is the same in every cell, so why won't is do the function for that word?

I have attached the spreadsheet, if you go to any day tab, any cell from G16→G22, if you put in Nursling, then try and get a response in H#, I can't...

Any help would be appreciated....

Snowmonster

[FDibbins]

Your post does not comply with Rule 8 of our Forum RULES. Do not crosspost your question on multiple forums without including links here to the other threads on other forums.

Cross-posting is when you post the same question in other forums on the web. The last thing you want to do is waste people's time working on an issue you have already resolved elsewhere. We prefer that you not cross-post at all, but if you do (and it's unlikely to go unnoticed), you MUST provide a link (copy the url from the address bar in your browser) to the cross-post.

Expect cross-posted questions without a link to be closed and a message will be posted by the moderator explaining why. We are here to help so help us to help you!

Read this to understand why we ask you to do this, and then please edit your first post to include links to any and all cross-posts in any other forums (not just this site).

http://www.mrexcel.com/forum/excel-q...-function.html

[XOR LX]

@FDibbins

Can I reply to this post now? I see a link in the original thread, but just wanted to check.

I'm a bit wary now after receiving an infraction for this very thing a few days ago!

Cheers

[FDibbins]

XOR, thanks for asking, and yes, tat was just info saying that we require the link - which I have provided

[Pepe Le Mokko]

Brrrrrr, lots of merged cells

[RobertMika]

@Peppe
Yes brrrr but this is not the problem.
I have deleted and recreated column BH and everything works fine
431 DriveReportWC12012014-1.xlsx

Not sure what the problem thru.

[XOR LX]

@FDibbins

Thanks for the confirmation!

@Pepe

What's wrong with merged cells?

[Snowmonster]

Thanks...