Shortening an index formula

[APowell]

Hi,

The formula below is a lookup using multiple values. It works well however I feel as if it could be neater. I am also bordering on the nesting limits if I would like to add any additional formulae. Could you please help me shorten it?

=IF(ISNA(INDEX('MRV'!A:O,MATCH(1,(F2='MRV'!G:G)*(C2='MRV'!A:A)*(E2='MRV'!N:N),0),11)),
IF(ISNA(INDEX('MRV'!A:O,MATCH(1,(F2='MRV'!I:I)*(C2='MRV'!A:A)*(E2='MRV'!N:N),0),11)),
IF(ISNA(INDEX('MRV'!A:O,MATCH(1,(G2='MRV'!G:G)*(C2='MRV'!A:A)*(E2='MRV'!N:N),0),11)),
IF(ISNA(INDEX('MRV'!A:O,MATCH(1,(G2='MRV'!I:I)*(C2='MRV'!A:A)*(E2='MRV'!N:N),0),11)),
"Unable to match",
INDEX('MRV'!A:O,MATCH(1,(G2='MRV'!I:I)*(C2='MRV'!A:A)*(E2='MRV'!N:N),0),11)),
INDEX('MRV'!A:O,MATCH(1,(G2='MRV'!G:G)*(C2='MRV'!A:A)*(E2='MRV'!N:N),0),11)),
INDEX('MRV'!A:O,MATCH(1,(F2='MRV'!I:I)*(C2='MRV'!A:A)*(E2='MRV'!N:N),0),11)),
INDEX('MRV'!A:O,MATCH(1,(F2='MRV'!G:G)*(C2='MRV'!A:A)*(E2='MRV'!N:N),0),11))

Kind regards,

A

 

[wigi]

Hi

Welcome on-board.

You can use the IFNA function if you have one of the more recent versions of Excel. It replaces IF(ISNA(...

 

[APowell]

Thanks Wigi. Sadly I can't use that function in Excel 2010, however I have found a way around the prblem o the nesting limits by using separate cells.

Regards,

A

 

[wigi]

Sadly I can't use that function in Excel 2010

Strange, if you ask me.