Function 18)

Add Function SKIPVLOOKUP to active workbook

Using the function

=SkipVLookup( lookup_value , table_array , column_index_num , skip_count)

You can skip the first few finds and return the 4th item.  Also looks for cells to the LEFT of the value you found by using a negative number for the third argument.

This formula:       =SkipVLookup(A3,G:G,-2,3)
Would return the corresponding value from column ‘E’ if found because -2 columns from ‘G’ is ‘E’. It would also skip over the first three finds and return the value from the 4th row in which it found a match.


Queries | Lists | Find | Alter | Clean | Sum | Functions | Help | Misc