Turn IF function formula into check marks/tick

[rayted]

Hi guys,

Using the spreadsheet attached, I am pulling an interviewer number into cells - but I want a 'tick' instead of an interviewer number. Essentially these cells are for when an interviewer needs to be spoken to. It's a bit 'ugly' to have the interviewer number instead of a tick. It is linked to other spreadsheets so I dont know if this is possible or not.

See cells in column E, F, G and H.

Can anyone help?

Thank you.

[6StringJazzer]

Current formula (E6 as an example)

=IFERROR(VLOOKUP(C6,'\\ipsosgroup.ipsos.com\dfs\EMEA\United Kingdom\File\Ipsos Connect\Measurement Team\PAMCO\2018\Panel Management\Interviewers\[AMP 2018 - fails coded by interviewers_February_230318.xlsx]Interviewers to Contact Q3-Q4'!$A$8:$A$50,1,FALSE), "")

Suggested update:

=IF(ISERROR(VLOOKUP(C6,'\\ipsosgroup.ipsos.com\dfs\EMEA\United Kingdom\File\Ipsos Connect\Measurement Team\PAMCO\2018\Panel Management\Interviewers\[AMP 2018 - fails coded by interviewers_February_230318.xlsx]Interviewers to Contact Q3-Q4'!$A$8:$A$50,1,FALSE)),"","✓")

A bit difficult to test since you have external references but this seems to work.

[rayted]

Thanks, this worked!

[6StringJazzer]

You're welcome! Thanks for the rep, and thanks for marking your thread Solved!