LinkBack URL
About LinkBacks
Hi ALL,
I have a problem to do look up on 3 variables based on row and column no. from dynamic pivotable.
The question is on the file.
Could you pls help to check it for me? Thanks
Hi ALL,
I have a problem to do look up on 3 variables based on row and column no. from dynamic pivotable.
The question is on the file.
Could you pls help to check it for me? Thanks
Last edited by halimgunawan; 10-02-2024 at 09:26 AM.
Perhaps,
C12
One example for pivottable.
Please Login or Register to view this content.
Please Login or Register to view this content.
sorry, I have revised the example file.. could you pls help to check it? Thanks alot
Perhaps,
J8
=INDEX(B6:G11,J6,J7)
if we update the pivotable, and it has different range size?
also the pivot has 3 variables..
Maybe, you can change B6:G11 to B6:Z100 for large dataset.
If not, I can not offer more solution.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks