Vlookup Function with multiple worksheets
Hi guys,
I've been looking through the past discussions but could not find the answer
to my problem.
I have a document with several worksheets.
There are individual wkshts organized by location. They have the
location/professor and all the other info in them.
Then there are two summary wkshts, 1 organized by location, the other by
professor.
I am looking for the easiest way to keep the summary pages updated
automatically and right now,
I have a vlookup function on the wksht organized by professor.
Is there any way for me to be able to input a formula that would
allow me to search multiple worksheets for a text value "professor name"
and input the corresponding location and etc. under it?
Thanks guys
|