# Index help

#### Peter1973

##### Well-known Member
I am using the following :
=INDEX('Rota April to July'!\$A\$7:\$A\$1000,MATCH(\$B5,'Rota April to July'!\$C\$7:\$C\$1000,0))

I would like to if the cell in \$C\$7:\$C\$1000 is blank use \$D\$7:\$D\$1000 instead.

Any help appreciated

### Excel Facts

Easy bullets in Excel
If you have a numeric keypad, press Alt+7 on numeric keypad to type a bullet in Excel.

#### Dryver14

##### Well-known Member
=if(INDEX('Rota April to July'!\$A\$7:\$A\$1000,MATCH(\$B5,'Rota April to July'!\$C\$7:\$C\$1000,0))="",
INDEX('Rota April to July'!\$A\$7:\$A\$1000,MATCH(\$B5,'Rota April to July'!\$D\$7:\$D\$1000,0)),
INDEX('Rota April to July'!\$A\$7:\$A\$1000,MATCH(\$B5,'Rota April to July'!\$C\$7:\$C\$1000,0))

seems long i know, there may be a better way

Replies
23
Views
506
Replies
9
Views
209
Replies
3
Views
190
Replies
11
Views
241
Replies
1
Views
166

1,191,125
Messages
5,984,786
Members
439,911
Latest member
dk73

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