Multiple Criteria and Multiple results in Single Cell separated with Comma or Space

Hi
attached the sample spreadsheet and expected results. looking for a solution using excel functions. VBA solution not preferred because this spreadsheet will be shared to others and also kept in google sheet.

googled, search in this forum but not able to find with the exact result.

Appreciate your help!

Thanks

Hi
Thanks a lot for your response , very much appreciated for your help.
It solves my first question.
I have one more request, how to add two more criteria in to the VLOOKUP? or can we use IF function?

I assume you mean data in Columns A & B of "Data": if so concatenate them with Data in G

so guessing ...

in G2 of "Data"

=E2&" "& A2&" "&B2&IF(F2=F3,CHAR(10)&G3,"")

Hi
sorry for not explaining in detail in the last thread
My requirement is
4 Criteria's ( Flag, Importance, Room Name, Start Date) in 4 column and one result column in "data" tab.

in the report sheet.
(1) Flag - Its a drop down list menu and have 3 options - All ( all the data), Yes or No
(2) Importance - Its a drop down list menu and have 3 options - All (all the data), VIP or Normal
(3) Room Name in rows
(4) Start date in columns.

attached the sample data.

thanks once again for your help.

Why is Flag only in B1?

The attached (I believe) offers a much better was of presenting the data.

"Activities" tab contains the data to input into the Calendar (automatically) and you can have 7 entries per day although this could be extended.

Hi
after going through this excelforum suggestion prepared a sample spreadsheet.
this spreadsheet contains two tabs , one is "data" and other one "Report - By formula" (which is partially achieved report through formula)

"Data" sheet
(1) Multiple Criteria is picked from the Column B & Column D (two columns)
(2) Results (Multiple) from Column A
(3) two helper columns created as per suggestion ( H & I )

"Report - By formula" Sheet
(1) Primary requirement and looking for solution : Used VLOOKUP Function and achieved the result partially .
Problem is - on N6 it suppose to show multiple results (VH-1 & VH-2) but it shows only VH-1. ie. it picks the first instance only.
It can show the multiple result when the information are next to each other.
Can it be fixed with VLOOKUP or some other formula required?
(2) Optional requirement : Is the report can be based on the B1 - Dropdown selection?
(3) Optional requirement : Is the report can be based on the B2 - Dropdown selection?

thanks once again for your help.

Hi JBeaucaire
thanks for your reply.
i understood your earlier email and the contents after applied the formula in to the real time data.
can you please suggest me the VBA Codes ? In this case i need to maintain a offline file ( excel with VBA Codes) and online data (shared with other users to update the data at google sheets).
do you have suggestion to use the VBA Codes in google spreadsheet?

thanks in advance

Noted thanks.

please help If you have any VBA Codes to match this requirement
(1) Multiple criteria ( 2 until 4)
(2) Multiple results ( 0 to 6) shown in single cell.

thanks.

VLOOKUP or MATCH will only find the first value where there are duplicate/multiple "keys".

If you had use the "calendar" I offered then these problems would not occur.

Re requirements (2) and (3): it would be possible to generate a "dynamic" table based on "Data".

I nothing about Google Sheets.

Hi JohnTopley
Thanks for your suggestion.

I have gone through your calendar spreadsheet. Its a useful one but i don't think i can convert this solution to my current requirement.

as i mentioned before my requirement is - multiple criteria & multiple results in one single cell.

if i not mistaken i understood your example "calendar" spreadsheet is one criteria , multiple results restricted to 7 cells.

thanks for your support.

Each cell for a give date can have any data you choose: you could extended the number of rows per day from 7 if required.

Looking at your example I cannot find any date (day) which has more than 2 entries.

The example is with lesser data.
actual spreadsheet is with more information & complex structure.
(1) Dates Starting from 01Feb2017 to 15Apr2017
(2) Vehicle No. Only two is shown actually it is around 28
(3) Total work id is 147 and no of Vehicle is 28 , so total work id is 4000+ and open item between feb to april is around 2200.

Maximum work IDs on any one day?

Number of column & number of rows will not change include the Work ID's. Actually work ID's are unique and we reserved few for future.

update will be there on the various data
(1) Work Status ( Change from open to done or deleted)
(2) planned date ( change in dates)
(3) actual completion date ( change in dates)
let me know if you need further information.
solution by VBA or any excel formula will do
thanks for your help