How to use MATCH() to reference a row number with its column location

[sammiegirl]

The MATCH() command produces a row number. Is there a way to use that row number to reference a cell? For example, instead of typing A3 can you type the A and use the match commmand to be the 3? I tried using ADDRESS() at first but for some reason I could not get that command to work. If I can figure out this problem my entire spreadsheet will work.

[GeneralDisarray]

=INDIRECT("A" & Match())

Use indirect(), replace my Match() with whatever match function you were using and "join" it to the "A" with an ampersand

[AlKey]

What is the end result should be?

[Tony Valko]

Need more info.

MATCH returns the RELATIVE position of the lookup value within an array.

Ram
Sam
Pam
Lam
Tam
Jam
Bam

=MATCH("Pam",Array,0) = 3

Pam is the 3rd element of the array.

[Glenn Kennedy]

Posted this in the wrong place...

[Jonmo1]

I would use INDEX

=INDEX(A1:A100,MATCH(....))

As Tony pointed out, Match returns the relative position # of the matching value in the lookup range.
Not necessarily the actual Row#.

Make sure both the A1:A100 and the range used in the Match function use the same row #s.

[cbatrody]

=INDIRECT(CONCATENATE("A",MATCH(xx,xx:xx,x)))

[sammiegirl]

= MATCH("B","A" & INDIRECT("A"&MATCH("A",'input off vb scout'!AB1:'input off vb scout'!AB1000)):'input off vb scout'!AB1000,0)
Is that what you were saying?
Excel is telling me that the array is volatile

[sammiegirl]

= MATCH("B","A" & INDIRECT("A"&MATCH("A",'input off vb scout'!AB1:'input off vb scout'!AB1000)):'input off vb scout'!AB1000,0)
Is that what you were saying?
Excel is telling me that the array is volatile...

[Jonmo1]

What's the formula you were using before you decided to use match to vary the row #?

In other words, what would the formula ultimately look like with a Hard Coded Row# ?

[Tony Valko]

Explain in words what you're wanting to do.

Be very specific.