I'm trying to find where a specific item number is located within the range
of sheets. The name of the sheet is the location I need to know. In another
cell I want be able to look up that specific item number and return the
contents of a specific cell in the sheet that the item number is found in.
"Gordon" wrote:
jtinne wrote:
I need a couple formulas to search a range of sheets on my workbook.
The first one needs to be able to seach through a range of sheets (exp.
sheet 20 to sheet 27) and find my value then I want it to display the name of
the sheet it is on.
For that you need a VB Script.
Second is to seach a range of sheets then display a value of a specific cell
on that sheet it is found on.
Thank you for the help!
VLOOKUP doesn't "search" in the way that "Find" searches. It looks up
data in a table that meet certain criteria. In other words it returns a
value of a cell where that cell POSITION matches criteria that you have set.
What EXACTLY are you trying to achieve with this?
--
Interim Systems and Management Accounting
Gordon Burgess-Parker
Director
www.gbpcomputing.co.uk