Compare lists, return a value from 3rd listClosed

Question

Hello, 

I have two spreadsheets; one with a list of part numbers (list A) and the other with a list of part numbers (list B) AND part descriptions (list C).  The lists of part numbers are not equal.  I need to add the part description from list C to a new column next to the part number in list A if the value in list A is equal to the value in list B. 

Essentially I have a list of part numbers that I need to add the description to.  The second list of part numbers contains the descriptions, but the two list of part numbers are not identical.

Any help would be appreciated.

Configuration: Windows 7 / Firefox 7.0.1

TrowaD · Answer

Hi Brad, 

Let's assume that: 
List A is located on sheet1 within the range A1:A4. 
List B is located on sheet2 within the range A1:A4. 
List C is located on sheet2 within the range B1:B4. 

Sheet2 is sorted on list B. 

The following formula will then be put in B1 of sheet1: 

=IF(ISERROR(VLOOKUP(A1,Sheet2!$A$1:$B$4,2,FALSE)),"",VLOOKUP(A1,Sheet2!$A$1:$B$4,2,FALSE)) 

Best regards, 
Trowa

Compare lists, return a value from 3rd list

1 response

Similar discussions

Subscribe To Our Newsletter!