Is it possible to display values in adjacent cells if and only if a value is found in a table?
The formula below is located in cell C2 of the ProjectModel worksheet and it works correctly
=IFERROR(VLOOKUP(A2,Available!A:A,1,FALSE),"")
If the value in A2 is not found in the "Available" table...