VLOOKUP Won't Reference Another Sheet

FusiaSuede

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.

 

Andrée Starå

Hi,

Can you describe your process in more detail and maybe share the sheet(s) or some screenshots? (Delete/replace any confidential/sensitive information before sharing) That would make it easier to help. (share too, andree@getdone.se)

I hope that helps!

Have a fantastic day!

Best,

Andrée Starå

Workflow Consultant / CEO @ WORK BOLD