Access Beginner
Active Member
- Joined
- Nov 8, 2010
- Messages
- 311
- Office Version
- 2016
- Platform
- Windows
Hi Guys.
I cuurently have this formula
=IF(D3="",IF(D3="Grand Total","",INDEX('Pivot tables'!$B$58:$DE$74,MATCH(Select,'Pivot tables'!$A$58:$A$74,0),MATCH(Sheet3!$D3,'Pivot tables'!$B$57:$DE$57,0))))
I've added in the If statements at the beginning.
Expected result that if D3 equals either Blank or Grand Total, than it should return "", otherwise got ahead with the Index and Match part, which returns a $$ value.
What this does at present is return a value of FALSE, which I guess is working, but not the result I'm after.
I hope I have been clear
Using Excel 2007
I cuurently have this formula
=IF(D3="",IF(D3="Grand Total","",INDEX('Pivot tables'!$B$58:$DE$74,MATCH(Select,'Pivot tables'!$A$58:$A$74,0),MATCH(Sheet3!$D3,'Pivot tables'!$B$57:$DE$57,0))))
I've added in the If statements at the beginning.
Expected result that if D3 equals either Blank or Grand Total, than it should return "", otherwise got ahead with the Index and Match part, which returns a $$ value.
What this does at present is return a value of FALSE, which I guess is working, but not the result I'm after.
I hope I have been clear
Using Excel 2007
Last edited: