Results 1 to 2 of 2

Thread: Vlookup or Index the last or 1st Non zero value
Thanks Thanks: 0 Likes Likes: 0

  1. #1
    Board Regular
    Join Date
    Oct 2018
    Posts
    72
    Post Thanks / Like
    Mentioned
    1 Post(s)
    Tagged
    0 Thread(s)

    Default Vlookup or Index the last or 1st Non zero value

    Hi,

    There are quite a bit of lookup last or 1st non zero value in a row or column as below link

    http://www.xldynamic.com/source/xld.LastValue.html

    Is there a way to combined it with vlookup, OR sum(if(criteria, if(criteria,range))), so we can search a range based on some row and column match to locate a particular row or column for its 1st or last non zero value?

    Cheers,

    Peter

  2. #2
    Board Regular
    Join Date
    Sep 2013
    Location
    Blue Mountains, Australia
    Posts
    3,468
    Post Thanks / Like
    Mentioned
    5 Post(s)
    Tagged
    0 Thread(s)

    Default Re: Vlookup or Index the last or 1st Non zero value

    Yes, the techniques can be incorporated into bigger formulae.

    But what are you trying to do?

Some videos you may like

User Tag List

Tags for this Thread

Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

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