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 [email protected] Active No
0001 [email protected] Active No
0001 [email protected] Active No
0001 [email protected] Inactive Yes
0002 [email protected] Inactive Yes
0002 [email protected] Inactive Yes
0002 [email protected] Inactive Yes
0003 [email protected] Active No
0004 [email protected] Inactive Yes
0004 [email protected] Active No
-------------------------------------------
sheet2
-----------------------------------------
Enter ID= 0001
Details
ID Email Status Need Renewal
----------------------------------------------
0001 [email protected] Active No
0001 [email protected] Active No
0001 [email protected] Active No
0001 [email protected] Inactive Yes
---------------------------------------------
Bookmarks