Complex vlookup is it possable.

[jvoss]

Hi Everyone.

I have a very complex (or simple i hope) problem.

Here it is,

I have 2 sheets:
First Sheet I'll call "list" (Raw Data that is ever growing). 12+ Columns and growing & 10000 Rows.
Second Sheet I'll call "own" (yes this for a growing collection of items that i own.

(i'll post a workbook soon if needed)

in the "list" one column "b" started out as a unique value(value never repeats) no problem for Vlookup. but as the "list" grows this unique column "b" has grown to be not so unique. eg the value has been repeating.

in the "list" column "b" is associated to column "c" how is one of ~12 values.

example:[TABLE="class: grid, width: 500, align: center"]
<tbody>[TR]
[TD]Column A[/TD]
[TD]Column B
[/TD]
[TD]Column C[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]Tea[/TD]
[TD]AV[/TD]
[TD]USA[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]Tea2[/TD]
[TD]AV[/TD]
[TD]NOE[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]


In "Own" sheet i have a column F is the manual input column G and A are results of a vlookup in "list" worksheet.

[TABLE="class: grid, width: 500, align: center"]
<tbody>[TR]
[TD]Column A[/TD]
[TD]Column F[/TD]
[TD]Column G[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]Tea2[/TD]
[TD]AV[/TD]
[TD]USA Not correct results[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]Tea[/TD]
[TD]AV[/TD]
[TD]USA correct results[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]Bread[/TD]
[TD]AV2[/TD]
[TD]NOT (answer from a 3rd sheet)[/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]

Current code for Column "A" sheet "Own" is =IF(IFERROR(VLOOKUP(A2,List!B:B,1,FALSE),"")=A2,VLOOKUP(H176,List!B:C,2,FALSE),VLOOKUP(A2,List_2!E:H,4,FALSE))

for this example "List_2" dose not matter.

Using formulas how do i get the correct results???

Yes i have tried Index,Match no luck(i could be entering the wrong syntax),vlookup +1,
have not tried the helper column before 10000 items on raw sheet.

Need to do this with out reworking the RAW sheet. IS THIS POSSIBLE??????

 

[Aladin Akyurek]

You did it again. Can i get you a soda? that is the least i can do.

Sure...

I was close, so if i need to add more requirements i just put in a "IF" statement as true? and as long as the last "List" is always the same?

Yes.