Trying to find the correct formula
I am trying to create a formula that will find the correct value in a column in one sheet and paste the value of another column on the same sheet and "paste" on a second sheet. I tried many formulas and can't find the right one. I created a VLOOKUP() formula, but it only returns the first incidence. I need it to find all the instances.
I am attaching replicas of my sheets. Here are the details:
I need to find "Pending-PPRB" in the Lookup Combo column Project Intake sheet, then copy the Project Name to the Project column on the Pending Project Requests sheet. The VLOOKUP() works. but how do I get ALL the "Pending-PPRB" to post in the Pending Project Requests sheet? I tried dragging the formula down to autofill, but I keep getting the same first result. What am I doing wrong?
Pending Project Requests
Help Article Resources
Check out the Formula Handbook template!