How can I use a VLOOKUP function that concatenates based on a criteria?

Answer 1

You can try an IF statement for the criteria, if true use VLOOKUP, if false, do something else or return " ".