Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Collections Lookups
Hello -
I am having a bit of trouble looking up and returning certain values in multiple collections. Here is an example of my situation: I have 100 values in a single column range (Collection1) and 20 values in a second single column range (Collection2). I would like to lookup the values in Collection2 and determine if they exist in Collection1. If they do not exist, I want to be able to capture them in a separate worksheet. (An exception report if you will) It is fairly easy to determine if they do exist but my main problem is handling the cases where a match does not exist and an error results. Does anyone know of an efficient way to handle the errors and capture the unmatched data? Collection1 is essentially a list of open cost centers and Collection2 is a list of cost centers that have been charged to in the past month. I want to be able to determine if there are any cost centers being charged to that are not currently open (i.e in collection1) and display them in a separate sheet as an exception report. Any help is greatly appreciated. Dave |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
minimize the file size in a ppt with collections of many pivot tables | Excel Discussion (Misc queries) | |||
LOOKUPS - Creating LOOKUPs where two different values must BOTH be satisfied. | Excel Worksheet Functions | |||
Comparing Collections | Excel Programming | |||
Intersecting/Unioning Collections | Excel Programming | |||
Creating Collections 'on the fly' | Excel Programming |