PREVENTION OF MULTIPLE LISTINGS OF SAME DATA WITH VLOOKUP
 

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

PREVENTION OF MULTIPLE LISTINGS OF SAME DATA WITH VLOOKUP
 

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

PREVENTION OF MULTIPLE LISTINGS OF SAME DATA WITH VLOOKUP
 

Tom
applied a formula to my lookup worksheets to add a number to the front of
all the data in the lists. This gave me individual numbers for each instance
of a number depending on the qty of previous occurences.

Looked like =COUNTIF($R$1:R2,R3)
and =CONCATENATE(B3,R3) in cell beside that

Seemed to work anyway

Thanks for prev advice it helped me work this out

"Tom Ogilvy" wrote:

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