Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Combining information from 2 Spreadsheets into 1 | Excel Discussion (Misc queries) | |||
Combining Information from rows | Excel Discussion (Misc queries) | |||
Help with combining information | Excel Discussion (Misc queries) | |||
combining row information | Excel Discussion (Misc queries) | |||
Combining cell information | Excel Worksheet Functions |