If column B is empty and column C contains a value, show column A (also using Indirect to draw data from another workbook)

[JPrez123]

Hi all,

Longtime lurker/reader, first time poster!

I'm looking for some help creating (for me) quite an advanced excel formula. I think any separate part of this i'd be fine with but combined together has somewhat melted my brain. Any help would be greatly appreciated, new to forums so let me know if i've not added something or followed proper procedure.

1. The formula needs to draw data from the following indirect: (INDIRECT("'["&'Reference Sheet'!$E$2&"]"&'Data Sheet'!$T$7&"'!A13:A150000")
2. Needs to have the IF statement that does the function - if Column B is blank and column C has data then show column A
3. Also needs to condense the data using a pivot table so there are no blank cells in between entries.

As I say hopefully that makes sense, would be grateful if anyone can help coach me a bit (even if its just a step in the right direction) as I've hit a brick wall with it.

Thanks,
Jonathan

 

[Fluff]

Welcome to the MrExcel Message Board!

Cross-posting (posting the same question in more than one forum) is not against our rules, but the method of doing so is covered by #13 of the Forum Rules.

Be sure to follow & read the link at the end of the rule too!

Cross posted at: If column B is empty and column C contains a value, show column A (also using Indirect to [SOLVED]
There is no need to repeat the link(s) provided above but if you have posted the question at other places, please provide links to those as well.

If you do cross-post in the future and also provide links, then there shouldn’t be a problem.