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