Hi!

Well, there are several methods that can be used to extract data from a
table but the important thing to keep in mind is that the table needs to be
designed "properly" and that design will usually dictate which method is
best to use.

A good table design is one where the data can be found by definning the
intersection of a row and a column. That's what Index/Match/Match does. You
can also use Vlookup/Hlookup together with Match. You can also use
Offset/Match. You can also use Labels. Sometimes you may be able to use
other functions like Sumproduct to extract data from a table.

So, what it all boils down to is how the table is structured and what type
of data the table holds.

Without some VERY SPECIFIC details about what you're trying to do, it's
impossible to make a specific suggestion.

Biff

"Adam Kroger @hotmail.com" <adam_kroger<nospam wrote in message
...
Oops, the range is C3:AE28, I am definately not the best typist. You
should see my posts BEFORE I edit them. ;)

The reason I was hoping to find a way for excel to locate the correct cell
without specifyiong an address is; that the Workbook is still under
construction/evolution, and as I move things around, or figure out new way
to do them, I am having to constantly go back and repair other things.
Additionally, if I can find a cell by some type of lookup, it will solve
another problem I have been having. There are actually about 12 cells
scattered throughout the range I need to find in that manner; in 144
different ranges.

I guess the real question is:
Is there a function that you can use inside INDEX() that will search
the entire range for something, and if so, can you then offset the return
either verticley or horizontally, without having to create a custom
function?


"Biff" wrote in message
...
Hi!

INDEX(p1rn1,1,18)

p1rn1 is C2:AE28

the 1,18 retrieves what is in cell T3

Are you sure about that?

If the named range starts in row 2 (C2), then maybe this will return the
value in T3:

=INDEX(P1M1,2,18)

Either that or the named range is really C3:AE28 or maybe you meant T2?

So, is "Weap Dam Rec" in the first row of the named range?

You could use something like this:

=INDEX(P1M1,1,MATCH("weap dam rec",INDEX(P1M1,1,),0)+3)

But why use something like that if this works:

=INDEX(P1M1,1,18)

Biff

"Adam Kroger @hotmail.com" <adam_kroger<nospam wrote in message
. ..
I am currently using an INDEX() function to do a basic data retrieval by
specifying both the collumn and rows.
INDEX(p1rn1,1,18)

p1rn1 is C2:AE28

the 1,18 retrieves what is in cell T3
in cell Q:S3 (Cells Q3 - S3 are merged) is the text string "Weap Dam
Rec"

Is it possible to use INDEX(p1rn1,MATCH("Weap Dam Rec",?,?),?) to find
the data in T3, if so, what is the wording of the function? If INDEX()
can't do it, is there anyhting that can?

for the billionth time
Thanks
Adam