Home |
Search |
Today's Posts |
#1
![]() |
|||
|
|||
![]()
I am trying to help an Analyst at a police department. She is trying to
search crime data in Excel and put it into a calendar. I found an Excel Calendar on Microsoft's web site, each day is one cell. I then put a VLOOKUP formula that goes to another sheet and returns the crime based on the date. i.e. 8/1/2005 FALSE INFO TO OFFICER 8/1/2005 N&D/PARAPHERNALIA 8/1/2005 MUNI CODE/SOLICIT W/O PERMIT 8/2/2005 ASSAULT WITH DEADLY WEAPON 8/2/2005 BATTERY/SIMPLE The problem I can't figure out how to Loop the formula multiple times and CONCATENATE the results so I can paste them back into the Cell that contains the date. Any Ideas? Lenny |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
VLOOKUP and multiple columns | Excel Discussion (Misc queries) | |||
how do I use vlookup for multiple occurrences of the same value | Excel Worksheet Functions | |||
how do I use vlookup for multiple occurrences of the same value | Excel Worksheet Functions | |||
Vlookup with multiple conditions | Excel Worksheet Functions | |||
Can VLOOKUP return multiple answers based on several identical lo. | Excel Worksheet Functions |