Error #NO MATCH in VLOOKUP formula

I need help please...

I'm trying to use VLOOKUP formula and it only worked in one row! Tried to add a column to use the VALUE formula and the result is #INVALID as per below image.

I'm using the Project ID as a common factor...

Below the database:

Please help


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!