I am trying to create a sheet that will list what other sheets some of our
associates are on. Right now I am trying to use a VLOOKUP for this, but all
values next to the names remain 0. For example:
Joe Schmoe works on lines A, C, & F. Each line has its own excel sheet. Is
there any way to search all the sheets for his name and have them listed? I
thought Vlookup would work. Any ideas?