Function 17)
17) Add Function SkipVLookup
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