# =IF(ISNUMBER issues

#### Darkwater_Unispace

##### New Member
Hello

My first post so please bear with me. The basics of the formula is as follows:
If Cell O4 totals 0, it will return a values from A1 on tab Delta Master.
If Cell O4 totals 4, it will return a values from B1 on tab Delta Master.
If Cell O4 totals 8, it will return a values from C1 on tab Delta Master.
If Cell O4 totals 12, it will return a values from D1 on tab Delta Master.
If Cell O4 totals 16, it will return a values from E1 on tab Delta Master.
If Cell O4 totals 20, it will return a values from F1 on tab Delta Master.

They all work except the last one. When it totals 20, nothing happens.

Any ideas why? the code is below.

=IF(ISNUMBER(FIND("0",O4)),'Delta Master'!A1,IF(ISNUMBER(FIND("4",O4)),'Delta Master'!B1,IF(ISNUMBER(FIND("8",O4)),'Delta Master'!C1,IF(ISNUMBER(FIND("12",O4)),'Delta Master'!D1,IF(ISNUMBER(FIND("16",O4)),'Delta Master'!E1,IF(ISNUMBER(FIND("20",O4)),'Delta Master'!F1,""))))))

### Excel Facts

Bring active cell back into view
Start at A1 and select to A9999 while writing a formula, you can't see A1 anymore. Press Ctrl+Backspace to bring active cell into view.

#### Fluff

##### MrExcel MVP, Moderator
Hi & welcome to MrExcel.
If O4 is a number rather than text try
Excel Formula:
``=IF(O4="","",IFNA(INDEX('Delta Master'!A1:F1,MATCH(O4,{0,4,8,12,16,20},0)),""))``

#### Darkwater_Unispace

##### New Member
Hi & welcome to MrExcel.
If O4 is a number rather than text try
Excel Formula:
``=IF(O4="","",IFNA(INDEX('Delta Master'!A1:F1,MATCH(O4,{0,4,8,12,16,20},0)),""))``
OMG. you have saved me.... Thank you so so much

#### Fluff

##### MrExcel MVP, Moderator
You're welcome & thanks for the feedback.

Replies
1
Views
116
Replies
3
Views
110
Replies
5
Views
531
Replies
4
Views
108
Replies
0
Views
464

1,129,587
Messages
5,637,250
Members
416,963
Latest member
samfuge

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