VLOOKUP Formula Help Needed

Baris Meretuk
Baris Meretuk ✭✭
edited 12/09/19 in Smartsheet Basics

I have a VLOOKUP challenge :) 

1st sheet is a project portfolio and capturing project names and a project status in a traffic light system. On another sheet I want to calculate all the "green", "yellow" and "red" amounts in out portfolio. No issues there, but if I want to create a formula to get automatically all the names of the "green", "yellow" or "red" Project names into one cell in front of the calculated amount I am stuck. 

Does anyone know how I can get more then one TEXT from another sheet copied into my current one if the traffic light is on GREEN or any other color?

This formula is giving me a NO MATCH if there are more then one GREEN (or any other color) project: 

=VLOOKUP("Green", {Custom Feed_HR Program Dashboard_Cloud Tr Range 11}, 1)  

Thanks for your help.