Easy formula
I'm sure this is easy but I can't hink right now...its Friday. I just wanted
to do a nested IF, INDEX, MATCH. So that if the INDEX/MATCH = 0, it does
another one.
SO here is the formula: =INDEX('Sheet2!'$E$4:$E$3429,MATCH(Sheet1!C4,'Reta il
LCR'!$B$4:$B$3429,FALSE))
Basically if this ends up being 0, then I want it to do another INDEX/MATCH.
ANy thought? Thanks.
|