Results 1 to 6 of 6

Cut down formula?

Threaded View

  1. #1
    Registered User
    Join Date
    10-02-2012
    Location
    England
    MS-Off Ver
    Excel 2002
    Posts
    5

    Cut down formula?

    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
    Last edited by NewbieLee; 12-01-2012 at 05:01 PM.

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Tags for this Thread

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1