Load Rows data on the selection of data Validation list

Respective Genesis in Excel.

I want to load the actual data exist in the rows by selection value from the data validation list.

E.g I have two worksheet in one excel file. One has a data activities of persons with their name like two columns i have in which one exist the name of person and second exist the activities which they perform.

On the second sheet, i made a data validation list of all the person names

Now my requirement is, when i select a person name from the list, load all the data from the 1st sheet to second sheet. Is this possible without VB code, because i want to share it on the Google sheet with my boss, where VB sheet is not supposed to work.

Thanks in Advance.

Regards,
Atif Nasrullah

Maybe better if you have sample file and upload it at the forum, so the member can see the problem, and if lucky you have your solution too...

To attach your file, click "Go Advanced" button" and find Paperclip button to attach the file

Data Validation.xlsx

Agreed... I have uploaded the sample file.

Respected Concern,

The file is not showing the result properly. Kindly have a look again and revert back to me.

Thanks in advance

Sorry to say,

I just don't understand that where i need to enter the Ctrl+Shift+Enter! like when i select the value from the drop down list???

@atif

What kind results do you need? the micope21 results is fine, did you check file attach in post#4? you must CTRL-SHIFT-ENTER button together is for implemented the formula, its array formula, not just regular formula.

And when you select criteria from data validation, the formula is responding perfectly, hope it clear for you

Regards

I attached a screen shot. There is still a problem in the result, which i attached with the comments. Kindly have a look.

Sorry Atif, you're right something wrong with the results, Im fix it, hope it works this time... Pls see the file attach

Cheers
Azumi

Thank you sir.. Now it is working properly

Glad it works atif....

Dear Micope21,

I need your help again. As you observe the above, we are fetching the values against 1 validation. now i want to fetch the value against multiple condition/validation. but it is not working. I am entering the below formula, but not providing proper result. Please do the needful.

=IFERROR(INDEX('Daily Delivery Entry'!G4:G4000,SMALL(IF(AND('Daily Delivery Entry'!D4:D4000=G2,'Daily Delivery Entry'!C4:C4000=C2),ROW('Daily Delivery Entry'!C4:C4000)-ROW('Daily Delivery Entry'!C4)+1),1)),"")