View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Zuo Zuo is offline
external usenet poster
 
Posts: 24
Default Finding the cell loacation that matches a specific value in a rang

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