| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
Pull multiple data
Utilizing a similiar array formula to this one:
=IF(ISBLANK(A2),"",IF(D2<"","INFO",IF(NOT(ISNA(VL OOKUP(A2,'Stip & Ord'!IV_D,1,0))),"IAPT",IF(NOT(ISNA(VLOOKUP(A2,Rep ay!IV_D,1,0))),"RCPO","NOIP")))) Is there any way to set cell D2 as an option? For instance, currently by entering the date in field D2, the result will be "INFO". What I would like to do is continue using the initial formula, but if the result is "IAPT" or "RCPO", then I would like to pull their effective dates from their respective worksheets and place in D2. Is this a possibility? |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Sort pages? | Excel Discussion (Misc queries) | |||
| Pull Current Month's Data Out of List - Repost | Excel Discussion (Misc queries) | |||
| Combining data (numeric format) in multiple cells into one cell (t | Excel Discussion (Misc queries) | |||
| Multiple Data Validation Criterias | Excel Worksheet Functions | |||
| How do I pull in multiple data sets at once? | Excel Discussion (Misc queries) | |||
Threaded Mode
