On Thu, 11 Feb 2010 17:47:02 -0800, hmmm
wrote:

I'm trying to lookup a value in a list, but return the cell address (or row
number) of where the value was found instead of the value itself. So if my
table starts in A1 and looks like this...

3
4
5
6
7

When look up the value of 3 I want to return A1 (or 1). I would use a
macro, but that's not an option in this particular case.

Use the MATCH worksheet function.

If you just want to return a 1, then:

D1: 3

MATCH(D1,A1:A5)

If you want to return A1, then add the ADDRESS function:

=ADDRESS(MATCH(D1,A1:A5),1,4)
--ron