Match data from year 1 with year 2 data (Vlookup?)

**Xx7** · 06-16-2011, 02:19 PM

In the first blue column I have inventory names. I want to match these with the first pink column names so that on the individual rows there will be the same inventory lines for blue and pink.

**NBVC** · 06-16-2011, 02:54 PM

Are you trying to append 4 columns of info to the "blue" table?

If so insert a couple more column between the "blue" and "pink" tables.

So now first "pink" column is in column P..

Add formula to L7:

=IFERROR(INDEX(Q:Q,MATCH($A7,$P:$P,0)),0)

copy across 4 columns and down the table.

Is that what you're after?

**Xx7** · 06-16-2011, 03:26 PM

beauty, works great.

Additional issue: Since there are more pink items than blue. Is there a way to figure out what items are in pink, but not in blue. Then maybe list them below?

**NBVC** · 06-16-2011, 03:42 PM

In U7 enter: =IF(ISNA(MATCH(P7,$A$7:$A$43,0)),COUNT(U$6:U6)+1,"") copied down to get count of matches

in V7 enter: =MAX(U:U) to get total count

in A44 enter: =IF(ROWS($A$1:$A1)>$V$7,"",INDEX(P:P,MATCH(ROWS($A$1:$A1),$U:$U)))

copied down

in L44 enter: =IF(ROWS($A$1:$A1)>$V$7,"",INDEX(Q:Q,MATCH(ROWS($A$1:$A1),$U:$U)))

copied down and across.