Match + Reference
Posted by Michael on November 09, 2001 1:58 PM
I'm trying to use the cell value returned by the match function to refer to that cell. HOW?!
i.e. =match(a1,b1:b3000) returns 500... how do i use 500 as the cell reference to the c column?
Posted by Juan Pablo on November 09, 2001 2:01 PM
You can use
=ADDRESS(MATCH(A1,B1:B3000),3)
=INDIRECT("C"&MATCH(A1,B1:B3000))
Juan Pablo
Posted by Aladin Akyurek on November 09, 2001 2:03 PM
=ADDRESS(MATCH(A1,B1:B3000),3)
where 3 refers to column C.
Is this what you want?
Aladin
Posted by Aladin Akyurek on November 09, 2001 2:08 PM
Re: You can use
INDIRECT? :)
Aladin
============
Posted by Juan Pablo on November 10, 2001 5:51 PM
I agree... ( Thinking "C" & MATCH(A1,B1:B3000) )
