NEED HELP WITH INDEX/MATCH! Tried EVERYTHING!
I am really struggling with getting the INDEX formula to work, and I'am not sure where the hiccup is.
I have a sheet "Property Metadata" that I would like to autofill the columns based off of the "Prject ID" cell.
When I enter the "Project ID" in sheet "Property Metadata", I would like it to reference the "Project ID" column in my second sheet "Portfolio Property Intake Sheet" and return the data from the appropriate column (Property Name, Property Address, etc.)
I feel I have tried everything under the moon and am really stumped.
This is the sheet that holds all of the data:
This is the sheet that I would like to autofill based off of the Project ID:
Thank you in advance to anyone that can help!!!!