Formula and multiple If statements

[Access Beginner]

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

 

[repairman615]

Hello,

maybe:

=IF(OR(D3="",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)),"")

 

[repairman615]

Whoops, I think that was backwards...


=IF(OR(D3="",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)))

 

[Access Beginner]

Thanks Jeff,

Worked like a charm. Much appreciated!

Cheers