| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Finding the cell loacation that matches a specific value in a rang
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 ... 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 |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Finding the cell loacation that matches a specific value in a
Thank you to both it works.
"Rick Rothstein" wrote: 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 ... 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 . |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Finding the cell loacation that matches a specific value in a rang
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Vlookup not finding matches | Excel Worksheet Functions | |||
| Finding matches ( | Excel Discussion (Misc queries) | |||
| finding exact matches | Excel Worksheet Functions | |||
| Creating Bespoke Template - how do I bring up a specific data rang | Excel Discussion (Misc queries) | |||
| How to update a cell if a specific date is included in a date rang | Setting up and Configuration of Excel | |||
Hybrid Mode
