Using $ and % with indirect functions

[lilbirdie]

Hello,

I have a spreadsheet that I'm using offset/indirect functions with, and it works great until we get to the $ and % issue.

Basically, I need the function to return the numerical data WITH the symbol that's attached to it ($/%) ... Is this possible? I've tried every type of formatting, but nothing seems to work.

Should I be using a different function?

For instance,

My Reference cell says: $15
I'm using: =OFFSET(INDIRECT(Q5),0,11,1,1)
My Indirect referencing just presents: 15

I can't use formatting to fix this problem, since my reference cell is going to be a percentage 50% of the time.

Any help would be much appreciated!

Thank you!

[JBeaucaire]

Post up a sample workbook demonstrating

1) sample data
2) sample indirect() usage
3) Manually mocked up examples of what you're trying to get

Let us look at the issue directly.

Click GO ADVANCED and use the paperclip icon to post up your workbook.