Cut down formula?

[NewbieLee]

Hi,

I have a really long formula and I'm really not very good with Excel so I'm not even sure I totally understand it, but it works! The INDEX MATCH function returns a name, but then I added the ISERROR IF function because I was getting a lot of error messages when the value the match function wanted to match wasn't available and I wanted the cells to stay blank rather than display the error. This is it:

=IF(ISERROR(INDEX(Points!$A$5:Points!$A$43, MATCH(1, Points!$AX$5:Points!$AX$43,0)))," ",INDEX(Points!$A$5:Points!$A$43, MATCH(1, Points!$AX$5:Points!$AX$43,0)))

Is there anyway to shorten this? As you can see I've repeated the INDEX MATCH function twice, I'm sure there must eb a way to avoid doing this... If you need any extra info let me know

Thanks in advance

Lee

[Richard Buttrey]

Hi,

Perhaps

=IF(ISERROR(INDEX(Points!$A$5:Points!$A$43, MATCH(1, Points!$AX$5:Points!$AX$43,0)))," ")

[NewbieLee]

Thanks for the reply but that only returns FALSE

[FDibbins]

if you really are using 2002/3, then im not sure there is anything you can do to shorten that formula.

which part is causing the error msg? (use ths formula editor to check)

[Ace_XL]

In 2007 and later versions

Please Login or Register  to view this content.

Else you'll probably have to stuck with your original formula

[NewbieLee]

Yes I have an older version and I think I'm just going to stick with the original one, it's not a problem but would just make it easier for me if I could shorten it! I think I've just about gotten my head round the original one anyway

Thankyou for all your help.