Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Database Lookup
Hi,
I am trying to pull information from an array that contain these information. I need to be able to pull the information if the status is 'OPEN' along with the module name and start date. However, I can't do a sort because these modules are in separate projects which are right on top of each other, so to sort would throw everything else off. I tried using vlookup in array form, which kind of worked but it lagged the entire worksheet to almost unbearable lengths and it did not update automatically. Is there some vba code or some other way to do it? Pivot tables are also very difficult to use in this case because there are many hidden columns of calculations between each requirement I need to pull out Status Module Start Date Open B 8/12 Close A 8/15 Open C 8/11 Open B 8/12 Thanks |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
lookup database | Excel Worksheet Functions | |||
database query not showing foxpro database How I import data | New Users to Excel | |||
Lookup information in Access Database | Excel Discussion (Misc queries) | |||
Code to 'lookup' value in Access database | Excel Discussion (Misc queries) | |||
Database Lookup | Excel Worksheet Functions |