Concatenate error across 2 worksheets with vlookup error

Problem:
1. The TAB “NEW TAXONOMY MASTER” should have the most updated “NEW COMMODITY CODES” (Column I), however I didn’t realize that as I was updating the new commodity codes in the TAB “DUPLICATE COMMODITY NAMES-CODES” (Column I) the CONCATENATE of the similar fields wouldn’t match up.
2. I need to fix this issue so that by CONCATENATING the fields I can perform a VLOOKUP in the NEW TAXONOMY MASTER tab to fill out “REMOVE DUPLICATE COMMODITY NAMES” (Column U) AND “REMOVE DUPLICATE COMMODITY CODES”.
3. As you can see not only is there a CONCATENATE issue, but the VLOOKUP for the fields that should return a value are returning a “0” (only about 30 rows of data changed). The N/A’s make sense because not every row had a REMOVE.
Fix Requested:
1. Resolve the CONCATENATION ISSUE so that the sheets can communicate with each other (the Family, New Category, New SubCategory, New Commodity Name and OLD Commodity Code never changed if that helps with finding a constant value. If you need to create a new column that’s fine.
2. Resolve the VLOOKUP ISSUE so that once the concatenates are consistent, the VLOOKUP will bring in values for “REMOVE DUPLICATE COMMODITY NAMES” (Column U)
3. Resolve the VLOOKUP ISSUE so that once the concatenates are consistent, the VLOOKUP will bring in values for “REMOVE DUPLICATE COMMODITY NAMES” (Column V)

Thank you soooo much! I really boxed myself in here and need help.

Penny

Concatenate should be simple - then 1 check to see if there is the number on the sheet (countif>0) 2. then check to see if the lookup returns blank cell (Vlookup<>"") then vlookup:

Please Login or Register  to view this content.