Hi.. Using Vlookup I can find the data I'm looking for in a sorted list. I then want to find the next occurrance of the same data so in effect I want my VLOOKUP table_array to be altered to start one row after where the original data was found. I may then want to find a third instance of the same data so the table_array range would need to start one row later again. Can you give me some pointers on how would I do this?

EG - If I use: =vlookup($a$1,Data!$A$1:$D$50,1,false)


to find my target string and it finds it in the 'Data' sheet in row A27 how would I find the next occurrance without manually altering my function to
=vlookup($a$1,Data!$A$28:$D$50,1,false)?
(That is A27+1 so that it starts looking in the remainder of the table_array to find any other instances.)

Thanks in advance.