Hi,

I am trying to lookup the value of one column in one worksheet in another
workbook that has about 20 sheets. I know how to do a lookup seperately in
each sheet but is there not a way that I can just do the one lookup from the
one sheet which will search the whole workbook (looking into each of the 20
sheets) and return what i am looking for. Essentially i just need to know if
the people on this one column are presesnt in any of the 20 sheets in another
workbook.

Thanks.