Am I using the VLOOKUP right? VLOOKUP not returning a value I want

Hi all,

Please can someone help with a VLOOKUP whereby I want a text to be returned.

In short, I have 300 interviewers of which, 39 are targeted (need to be monitored). I have a filter on which interviewers are targeted. I want to run a VLOOKUP which if it identifies interviewers as being on my main list of 300 interviewers, text or a value is returned to say 'YES' (basically telling me that these are the targeted interviewers), so I can copy and paste it on to my master list.

Please see my spreadsheet with attempted vlookup attached. The first tab has all the interviewers, the 2nd tab is the small list of interviewers I am referencing (looking to identify who is targeted).

Thank you!

hi there. just a slight problem. you did not fix the rows. your formula in F3 is:
=VLOOKUP(A3,Sheet3!A1:G34,7,FALSE)

because you did not fix the row, copying downward becomes:
=VLOOKUP(A4,Sheet3!A2:G35,7,FALSE)

so simply lock the row in F3 by adding these dollar signs on the left of the row number:
=VLOOKUP(A3,Sheet3!A$1:G$34,7,FALSE)

you could also use:
=VLOOKUP(A3,Sheet3!A:G,7,FALSE)

and to prevent NA from showing:
=IFERROR(VLOOKUP(A3,Sheet3!A:G,7,FALSE),"Not Found")
or:
=IFERROR(VLOOKUP(A3,Sheet3!A:G,7,FALSE),"")

your VLOOKUP finds A3 in Sheet 3 column A and returns the 7th column's value on the same row.

if you just need to know if they are in Sheet3:
=IF(COUNTIF(Sheet3!A:A,A3),"YES","NO")

Awesome. Many thanks!!

Try this in F3

Formula:

Please Login or Register  to view this content.