MrExcel Publishing
Your One Stop for Excel Tips & Solutions

Simple problem...but's it's driving me spastic


Posted by Peter C on March 25, 2001 11:24 PM

I need a formula that returns a cell reference (in R1C1 style. Using a reference, it looks it up in an array. For example, looking up reference "November" in array A1:A12 will return "A11".

Cheers


Posted by Dave Hawley on March 25, 2001 11:28 PM


Hi Peter

Sounds like you need the MATCH formula nested with the ADDRESS formula>

=ADDRESS(MATCH("November",A1:A12),1,,0)


Dave

OzGrid Business Applications

Posted by Dave Hawley on March 25, 2001 11:30 PM

Oops small Typo!

=ADDRESS(MATCH("November",A1:A12,0),1,,0)
OzGrid Business Applications

Posted by Peter C on March 26, 2001 1:35 AM

Thanks Dave, works perfectly