Hi all
Is it possible to use HLOOKUP (or any other function) to return details of the 2nd (or 3rd) instance of a value?
E.G. If I have a list...
1 2 3 4 1 5 6 7 1
a b c d e f g h i
I want to have a section that displays the values of the first 3 instances something like:
(looking up "1")
1st = a
2nd = e
3rd = i
At the moment all I can do is just get the 1st value, it is no good changing the lookup table as I will never know the order of the list.
Thanks for your help in advance guys!
Is it possible to use HLOOKUP (or any other function) to return details of the 2nd (or 3rd) instance of a value?
E.G. If I have a list...
1 2 3 4 1 5 6 7 1
a b c d e f g h i
I want to have a section that displays the values of the first 3 instances something like:
(looking up "1")
1st = a
2nd = e
3rd = i
At the moment all I can do is just get the 1st value, it is no good changing the lookup table as I will never know the order of the list.
Thanks for your help in advance guys!