Indirect formula not working

[gheyman]

I am using an indirect formula to pull data of other tabs. The tab names are compiled and placed on a tab through VBA code (pretty much a cut and paste)

My problem is that the formula is not calculating because what I am assuming is the format of the data in column B.

If I type over the data (exactly the same) the formula works. I know its not mispelling because the code is using a formula to pull the tab nam in.

Anyone run into this problem and came up with a solution?

=IF(ISERROR(INDIRECT($B2&"!U2")),"",INDIRECT($B2&"!U2"))

PS the format of the Text in Column B is "General" and yes I tried changing the format of the names to Text, Number......

Thanks for the help!

 

[njimack]

Does the text in column B contain spaces? If so, you need an apostrophe within your INDIRECT function. Or you could combine it with ADDRESS. Something like this maybe:
INDIRECT(ADDRESS(2,21,,,$B2))

 

[T. Valko]

I am using an indirect formula to pull data of other tabs. The tab names are compiled and placed on a tab through VBA code (pretty much a cut and paste)

My problem is that the formula is not calculating because what I am assuming is the format of the data in column B.

If I type over the data (exactly the same) the formula works. I know its not mispelling because the code is using a formula to pull the tab nam in.

Anyone run into this problem and came up with a solution?

=IF(ISERROR(INDIRECT($B2&"!U2")),"",INDIRECT($B2&"!U2"))

PS the format of the Text in Column B is "General" and yes I tried changing the format of the names to Text, Number......

Thanks for the help!

Are you sure there are no unseen whitespace characters in the cell before you over write it?

Does this make a difference:

=IF(ISERROR(INDIRECT(TRIM($B2)&"!U2")),"",INDIRECT(TRIM($B2)&"!U2"))

 

[gheyman]

You're probably right. I will check it now. There are spaces and that is most likely whats happening. The one that I chose to "write" over did not have any spaces.

THANKS