| Home |
| Search |
| Today's Posts |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
compare two lists
Hi,
your formula would work if I had concord sorted, but I have other concord in other states. ex. CA Concord CA Walnut Creek CA Pittsburg PA Concord saman110 wrote: Hello, I would like to compare two wks and copy the corresponding data. For example. In Sheet 1 I have: Concord 94518 Concord 94519 Concord 94520 Concord 94521 Concord 94523 In Sheet 2 I have: Concord Concord Concord Concord Concord Concord Concord Concord The result I should get in Sheet 1: Concord 94518 Concord 94519 Concord 94520 Concord 94521 Concord 94523 Concord 94518 Concord 94519 Concord 94520 Any Help? Thx. -- Message posted via OfficeKB.com http://www.officekb.com/Uwe/Forums.a...excel/200710/1 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| compare lists | Excel Worksheet Functions | |||
| compare name lists | Excel Worksheet Functions | |||
| Compare lists | Excel Worksheet Functions | |||
| Compare two lists? | Excel Discussion (Misc queries) | |||
| compare two lists | Excel Discussion (Misc queries) | |||
Threaded Mode
