Thread: how do I use vlookup for multiple occurrences of the same value
View Single Post
  #10   Report Post  
Harlan Grove
 
Posts: n/a
Default
"Harlan Grove" wrote...
....
I2:
=MATCH(G$1,OFFSET(Tbl,I1,0,G$2-I1,1),0)
....

Oops, make that

I2:
=MATCH(G$1,OFFSET(Tbl,I1,0,G$2-I1,1),0)+I1


Reply With QuoteReply With Quote