My Account
Sign up, and you'll be able to ignore users whose posts you don't want to see.
Sign up
Report problem with this ad
Start a related thread
Start a related poll
Reply via Boardmail
May 22, 2015
10:52
:22
am
Blue Print
You can't use indirect with a pivot table.
Because a pivot table is not really a cell based entity you can't access it that way. Try to work around it with a vlookup instead.
Start a related thread
Start a related poll
Reply via Boardmail
Report problem with this ad
Blue Print
Bio page
Blue Print
Joined
Sep 7, 2001
Last login
Apr 19, 2024
Total posts
29,176 (5,432 FO)
Report problem with this ad
Messages
Author
Time
Excel experts - having trouble with INDIRECT()
BYUCoug11
5/22/15 10:18am
You can't use indirect with a pivot table.
Blue Print
5/22/15 10:52am
Also you can use GetPivotData() as follows:
Blue Print
5/22/15 10:53am
I'm using it in a different column with pivot data without issue
BYUCoug11
5/22/15 11:03am
Report problem with this ad
Posting on CougarBoard
In order to post, you will need to either
sign up
or
log in
.
Report problem with this ad