VLookup 2nd 3rd & 4th occurrence.
I can not get the array you advised of to work
As I could not get the array working I continued with the lookup as you said
"The formula above can be generalized" I though it could not be too hard,
I have extended my table from A1:B6 to A1:B16, same data just more of it.
This is what I posted last night and finds the second match
So what I though would work is if where "A1" is in this part
MATCH($C$1,A1:A16,0), If I inserted another indirect match it would find the
second match add 1 to the row and the find the 3rd match.
All I get back is #N/A
Could you shed any light on where I am going wrong or how you would do it.
If you have time would you mind sending a partial sheet where you have it
working, this will get rid of any typo's I create :o)
Many Thanks it is most appreciated.
> >I am trying to match the first, second, third and fourth occurrence of a
> >time in using VLookup.
> >Here's what I have:-
> > A B C
> >1 0800 10 0800
> >2 0830 10
> >3 0800 11
> >4 0830 11
> >5 0800 12
> >6 0830 12
> >The times in column A range from 0000 to 2330 and are repeated up to 4
> >times. The data in column's B,C,D,Etc changes with each occurrence.
> >C1 = what I want to match
> >A1:B6 = My table
> >I have found this in this NG:-
> >Which match's the second occurrence, How do I adapt it to match t