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.

Find more posts tagged with

Cell linking

Comments

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

Sign in to join the conversation!

Quick Links

Trending discussions

Grid creation
Hi All, I have a sheet that I am creating to gather powder coat thickness data. The problem I have run into is that they can do up to 5 checks on the same line during the same day and shift. Then they get the average of those measurements to use for the day to determine if the thickness passed or failed. If I have a form…
APPROVAL SETTING VIA "ADVANCED OPTIONS" - APPROVAL WORKFLOW
Hi All, Need you support for the the issue. I was in the process of making an approval workflow for petty cash request, the problem was when i want to combine 2 different confirmation workflow by Requester to be appear in same column (Confirm), but mention notification like in the screenshot attached. The workflow consist…
Share Tab not activated
New to smart sheet pro and I desire to share to viewer, share tab not activated...how do I activate and share a sheet with a viewer?