From: Zuo on 24 Feb 2010 16:18 Hi, I have a list of references in column A going from A3:A240. I need a formula that can find a specific reference within that range and give me back the location of the reference. Example: A1 7569 A2 1245 A3 3256 A4 7895 If I input 3256 it needs to return either A3 or 3. Thanks, ZUO From: Rick Rothstein on 24 Feb 2010 16:23 This maybe... =MATCH(3256,A1:A100,0) Although I would probably use a cell reference in place of the hard-coded 3256 value. -- Rick (MVP - Excel) "Zuo" wrote in message news:F6225750-C572-44A1-A914-083DFF38A1FC(a)microsoft.com...> Hi, > > I have a list of references in column A going from A3:A240. I need a > formula that can find a specific reference within that range and give me > back > the location of the reference. > > Example: > > A1 7569 > A2 1245 > A3 3256 > A4 7895 > > If I input 3256 it needs to return either A3 or 3. > > Thanks, > > ZUO > From: Max on 24 Feb 2010 17:00 In B1: 3256 In C1: ="A"&MATCH(B1,A:A,0) will return "A3" -- Max Singapore --- "Zuo" wrote:> I have a list of references in column A going from A3:A240. I need a > formula that can find a specific reference within that range and give me back > the location of the reference. > > Example: > > A1 7569 > A2 1245 > A3 3256 > A4 7895 > > If I input 3256 it needs to return either A3 or 3. > > Thanks, > > ZUO >