Reference a row in a column?

In my attachment, I need to reference Row 5 on 'All Accounts' and show the results of those formulas in Column E of 'Account Listing'

So that if I change anything throughout the other sheets the formulas will take over, and I won't have to adjust anything on 'Account Listing'

If this isn't an "easy fix" then I can just copy, past values only, then transpose them in the column. But, if it's pretty easy, I'd like to have them reference correctly so I don't have to do that every time we change something.

Any help is greatly appreciated. And yes, I'm quite ashamed that I don't know how to do this.

When you say row 5, do you mean D5? or F5? or both?

You can always use named Ranges... that you can use in any cell... i.e. If your used "total" as a named range for D5 then you could use something like:

Please Login or Register  to view this content.

Or something along those lines... I think that is what you are looking for but not 100% sure.

You just made my day. That works perfectly. It does exactly what I want it to do. It may look very simple to you, but I just couldn't make anything work. Thank you so much for doing that for me. I really appreciate it.

FDibbins' formula did it. It didn't work when I pasted it, so I typed it. It was just a sheet name that it didn't recognize. I think you left off "Listing" in 'Account Listing'. Works perfectly though. Here's the formula as I have it.

=INDEX('All Accounts'!$F$2:$FS$5,4,MATCH('Account Listing'!A6,'All Accounts'!$F$2:$FS$2,0))

And thanks again.