Vlookup finds the first matching instance. So any successive formulas
looking for the same value will return the same result.

You might have to use some form of array formula that returns a list of rows
that fill the conditions and successively pull the each row out (SMALL
function) to feed to the Index function. It is really a compound formula
written specifically to the situation, which I am only guessing at.

Another alternative is to write code that extracts the data or look at the
data in place using autofilter or even in another location using Advanced
Filter.

--
Regards,
Tom Ogilvy


"RADIOOZ" wrote:

AM TRYING TO STOP MULTIPLE LISTINGS OF DATA IN COLUMNS WHEN USING THE VLOOKUP
COMMAND. NEED SOME IDEA OF HOW TO CHECK CELLS ABOVE THE ONE i AM ENTERING THE
DATA INTO AND APPLYING RESULTS TO THE ROW OF LOOKUPS