Help with INDEX and MATCH using two INDEX columns

[Sean15]

Hi:

The formula below is return required value from range N if value in E470 is greater than zero. But if value is less than zero, I want to return value from range O.

How can I adjust formula to return value in range O


IF(E474>0,INDEX(Sheet1!$N$15:$N$42,MATCH('CF WS'!B474,Sheet1!$M$15:$M$42,0)))


Thanks for your help.

Sean

 

[jtakw]

Hi,

What about when E474 is Exactly zero?
This modified formula uses Range N for >0, and uses Range O for zero or less:

=INDEX(IF(E474>0,Sheet1!$N$15:$N$42,Sheet1!$O$15:$O$42),MATCH('CF WS'!B474,Sheet1!$M$15:$M$42,0))

 

[Sean15]

Hi:

Excellent, thank you very much.

Sean

 

[jtakw]

You're welcome.