Easy formula
 

Hi

Try:

=IF(INDEX('Sheet2!'$E$4:$E$3429,MATCH(Sheet1!C4,'R etail
LCR'!$B$4:$B$3429,FALSE))=0,other
formula,INDEX('Sheet2!'$E$4:$E$3429,MATCH(Sheet1!C 4,'Retail
LCR'!$B$4:$B$3429,FALSE)))


HTH
Jean-Guy

"A.S." wrote:

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.