=IF(ISNUMBER issues

[Darkwater_Unispace]

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

 

[Fluff]

Hi & welcome to MrExcel.
If O4 is a number rather than text try

=IF(O4="","",IFNA(INDEX('Delta Master'!A1:F1,MATCH(O4,{0,4,8,12,16,20},0)),""))

 

[Darkwater_Unispace]

Hi & welcome to MrExcel.
If O4 is a number rather than text try

=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]

You're welcome & thanks for the feedback.