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