give the name if it exists and #N/A if it doesnt

[ewong]

i have 2 sheets

each sheet has a column called employee name

i want to have a new column (column b) with a formula in sheet1 that would check if all names in sheet1 are also in sheet2 or not

e.g.: if john doe is in sheet1 and sheet2, then it will give john doe in column b. if he's in sheet1 but not in sheet2, then it will give #N/A

whats the formula for this?

was thinking of vlookup but not sure how to do it. thanks!

[protonLeah]

Please Login or Register  to view this content.