V Look Up Help

[ElzyP]

Hi there!

I'm working in a spreadsheet that has a sheet for months Jan - Aug with a list of names in each, I then have a separate sheet that has a list of names including ones that aren't found in months Jan - Aug.

What i'm trying to do is search in months Jan - Aug for the names that appear in the 'total names list', and if they do appear then for a 'Yes' to be the result.



I've managed to get the formula to work if i'm just looking at two months, but if I try and add in any more months it won't work.

=IF(ISNA(VLOOKUP([@Name],Jan[Name],1,0)),IF(ISNA(VLOOKUP([@Name],Feb[Name],1,0)),"No","Yes"),"Yes")




I've then tried this formula but it is bringing up 'No' for everyone:
=IF(ISERROR(IFERROR(VLOOKUP(Table15[@Name],March1[Name],1,FALSE),IFERROR(VLOOKUP(Table15[@Name],Jan[Name],1,FALSE),IFERROR(VLOOKUP(Table15[@Name],Feb[Name],1,FALSE),"No")))),"Yes","No")


Any help would be greatly appreciated!! Can give more description/detail if needed.

Thanks

 

[123rickfear]

=IFERROR(VLOOKUP(A1,Jan!A:A,1,0),IFERROR(VLOOKUP(A1,Feb!A:A,1,0),IFERROR(VLOOKUP(A1,Mar!A:A,1,0),IFERROR(VLOOKUP(A1,Apr!A:A,1,0),IFERROR(VLOOKUP(A1,May!A:A,1,0),IFERROR(VLOOKUP(A1,Jun!A:A,1,0),IFERROR(VLOOKUP(A1,Jul!A:A,1,0),IFERROR(VLOOKUP(A1,Aug!A:A,1,0),""))))))))

something along those lines. however it won't give you a yes or no, it will give you the person's name.