Hi, everyone,

I have a set of values as shown below in sheet1. All I need to do is I need to retrieve this info in sheet 2 when I enter the ID as shown below. I have tried with vloopup formula, but I am able to get only one value which is on the top and not the rest, please help me to do it.

sheet1
---------------------------------------------
ID Email Status Need Renewal
0001 a@gmail.com Active No
0001 b@gmail.com Active No
0001 c@gmail.com Active No
0001 d@gmail.com Inactive Yes
0002 a@gmail.com Inactive Yes
0002 b@gmail.com Inactive Yes
0002 c@gmail.com Inactive Yes
0003 a@gmail.com Active No
0004 a@gmail.com Inactive Yes
0004 b@gmail.com Active No

-------------------------------------------

sheet2
-----------------------------------------
Enter ID= 0001

Details

ID Email Status Need Renewal
----------------------------------------------
0001 a@gmail.com Active No
0001 b@gmail.com Active No
0001 c@gmail.com Active No
0001 d@gmail.com Inactive Yes
---------------------------------------------