Combining information from two excel list

G

gueyo

I have two excel list
The firts list has 3 columns of info like this:
A B C

Part# Description Price
100-EZ367 SWING BACK SEAT 264.29
100-7100F1 BLUE WATER CHAIR 95.99
1-031791 ST CONTROL 41.99

The Second List has two colums like this:
A B
Part# Match
100-EZ367 Error: No Products
100-7100F1 found 0 matches
1-031791 found 0 matches

I want to compare "List 1 - Column A" to "List 2 - Column A" and if the
number is found I want the information in "List 2 - Column B" brought into
"List 1-Column D"


Thank you.
 
S

Sean Timmons

Assuming second list is on sheet2:

In D2:
=IF(ISNA(VLOOKUP(A2,Sheet2!A:B,2,0)),"",VLOOKUP(A2,Sheet2!A:B,2,0))

will retun a blank cell if not found...
 
K

KC

Part# Description Price Column D formula
100-EZ367 SWING BACK SEAT 264.29 =VLOOKUP(A2,$A$7:$B$9,2,FALSE)
100-7100F BLUE WATER CHAIR 195.99 =VLOOKUP(A3,$A$7:$B$9,2,FALSE)
1-031791 ST CONTROL 41.99 =VLOOKUP(A4,$A$7:$B$9,2,FALSE)

Part# Match
100-EZ367 Error: No Products
100-7100F found 0 matches
1-031791 found 0 matches

where $A$7:$B$9 is the range of 2nd list

-kc
*Click YES if this helps
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top