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
|