OK, if the lookup function wont do what i want it to is there a macro that
can do the job? do you have a code?

any help would be much appreciated.

"Jim Rech" wrote:

is there not a way that I can just do the one lookup

The Excel lookup worksheet functions all search one range on one sheet so
you'd need multiple lookups.

--
Jim
"Zak" wrote in message
...
| 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.