# Formula and multiple If statements

#### Access Beginner

##### Active Member
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

Last edited:

### Excel Facts

How to total the visible cells?
From the first blank cell below a filtered data set, press Alt+=. Instead of SUM, you will get SUBTOTAL(9,)
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)),"")

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)))

Thanks Jeff,

Worked like a charm. Much appreciated!

Cheers

Replies
1
Views
183
Replies
2
Views
670
Replies
1
Views
461
Replies
12
Views
382
Replies
9
Views
353

1,196,292
Messages
6,014,512
Members
441,826
Latest member
roudarreza

### We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.

### Which adblocker are you using?

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

### Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

### Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back