Combining information from two excel list
 

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.
--
gueyo

Combining information from two excel list
 

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...

"gueyo" wrote:

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.
--
gueyo

Combining information from two excel list
 

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

"gueyo" wrote:

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.
--
gueyo

Combining information from two excel list
 

Both of these answers worked thank you very much.
--
gueyo


"KC" wrote:

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

"gueyo" wrote:

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.
--
gueyo