Objective
VLOOKUP
always search in left column and get result from right side. How to make
VLOOKUP search in right column and get result from left column.
Translate
Showing posts with label VLOOKUP. Show all posts
Showing posts with label VLOOKUP. Show all posts
Tuesday, March 14, 2017
Monday, February 20, 2017
VLOOKUP Multiple Occurrence
Objective
Many
a times, while searching a list, the searched text/value may appear more than
once. Standard VLOOKUP will return first occurrence from top. The question is
how to find second, third or fourth occurrence?
Subscribe to:
Posts (Atom)