VLOOKUP Won't Reference Another Sheet
In my 'Install' sheet status column I have a formula
=IF(Health3 = "red", "At Risk", IF(Health3 = "yellow", "On Hold", IF(Health3 = "blue", "In Progress", IF(Health3 = "green", "Complete"))))
In my 'tracker' sheet i am trying to reference the the status column in the 'install' sheet.
=vlookup I've selected cell to reference but it keeps returning #incorrect argument set.
I can't seem to figure this out.