Hi All,
First up, thanks for any/all help. I have found generous helpers on this board before....so here's hoping............
I have a sheet with a list of names in the column A. I need a vlookup / or any formula which will search for the name in a whole other sheet instead of just a column (as in vlookup) and return a "present" or whatever in case it is found anywhere in the sheet.
Since I have to search for all names, I could not manually put in the names each time I want to find them. It would be great if it could be dragged down like a formula.
It is actually a system for marking attendance for people who log in.
Thanks again guys
Vcsush
First up, thanks for any/all help. I have found generous helpers on this board before....so here's hoping............
I have a sheet with a list of names in the column A. I need a vlookup / or any formula which will search for the name in a whole other sheet instead of just a column (as in vlookup) and return a "present" or whatever in case it is found anywhere in the sheet.
Since I have to search for all names, I could not manually put in the names each time I want to find them. It would be great if it could be dragged down like a formula.
It is actually a system for marking attendance for people who log in.
Thanks again guys
Vcsush