Lookup with multiple results between two workbooks
I hope someone can help me.
I have two different workbooks, one to track "tickets" written during the
month, this will correspond with a sheet in another workbook for each
employee. For ease of entry I am try to get the employee workbook do a
lookup of the name in the first workbook and return all results. I did get a
formula to work with lookup; however, it only returns the last ticket
written, there will be instances where more than one ticket is written to an
indivdiual within the month.
This is the function that I have that returns 1 result:
=LOOKUP('[Ticket Tracking.xls]March'!$I$89,'[Ticket
Tracking.xls]March'!$B$4:$B$600,'[Ticket Tracking.xls]March'!$D$4:$D$600)
How can I adjust this or write a new formula to return all results.
Thanks in advance
|