I have one excel file with two sheets. (sheet information not important here)
Sheet 1 has a list of names I manually input
Sheet 2 has a generated list of names that change hourly
One sheet 1 beside each name I type I would like the cell before the name to check if that name is already on the second sheet and insert a "Y" in the cell. If the name on sheet 1 is not on sheet 2 I would like the cell to come back with #N/A or "NO" or really anything but "Y" or "Yes"
Very urgent and thanks in advanced for your help!
-cody
Bookmarks