Worksheets

[Mike Psarras]

How can I locate a value in a worksheet but among
multiple worksheets. I don't want to use find&replace
from edit menu. I prefer to use a function such as
vlookup, match etc..
I appreciate your help

 

[Earl Kiosterud]

Mike,

Excel doesn't provide a lot of functionality for working across multiple
worksheets. It may be that my standard rant about putting the data in a
single worksheet (with additional columns as necessary, to differentiate
stuff) is indicated. People often split data into separate worksheet, and
miss out on a lot of Excel functionality. Tell us more about the data in
the sheets. Be specific. This may not sit well, but my be just what you
need in the long run.