E
Excel Help!
I need VLOOKUP to search across worksheets where the names are not the same
(example) Worksheet1 (A): Doe, John; Worksheet2 (A): DoeJ; Worksheet3 (A)
DoeJK. Can I have VLOOKUP find each name across worksheet 2 and 3? Here's
what I have: =IF(ISNA(VLOOKUP(A2,Sheet2!$A$2:$A$206,1,FALSE)),"no","yes").
Thanks for any help.
(example) Worksheet1 (A): Doe, John; Worksheet2 (A): DoeJ; Worksheet3 (A)
DoeJK. Can I have VLOOKUP find each name across worksheet 2 and 3? Here's
what I have: =IF(ISNA(VLOOKUP(A2,Sheet2!$A$2:$A$206,1,FALSE)),"no","yes").
Thanks for any help.