LOOKUP Question

S

shakey1181

When using V or H lookup, is there anyway to get the function to return the
reference for the second occurence of what it is looking for? So, I am
looking for the number 23, but it appears tiwce on the sheet and it is the
second one I need.

If that makes any sense, thanks in advance
 
P

Paul Lautman

shakey1181 said:
When using V or H lookup, is there anyway to get the function to
return the reference for the second occurence of what it is looking
for? So, I am looking for the number 23, but it appears tiwce on the
sheet and it is the second one I need.

If that makes any sense, thanks in advance
Click to expand...

I suggest that you look back in this forum for a post called VLOOKUP SECOND
APPEARANCE.

In that thread Ardus suggests a solution and also there is a pointer to Chip
Pearson's Arbitrary Lookup
 
R

Roger Govier

Hi

I came across a function written by JethroUK called JLOOKUP that will
allow you to pick up different occurrences of values in a Vlookup type
manner.
With Jlookup there is an optional additional parameter which permits you
to choose which occurrence to pickup.

The following link should take you to his original posting

http://makeashorterlink.com/?N38F6203D
 
Top