Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Find a Cell Value
Hello,
I'm just trying to find a cell value from one sheet to another. On Sheet1, I want say "B11" to be what I'm looking for. On Sheet2, I need it to search through say "C1:C5001" and have it select the first one it finds. How would I go about doing that? Thanks |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Find a Cell Value
Maybe not enough information but it sounds like you want something like
=index(Sheet2!B$1:B$5001,match(your_value,Sheet2!C $1:C$5001,0)) If "your_value" is in Sheet2!C11 then the formula returns Sheet2!B11 "Gabe" wrote in message ... Hello, I'm just trying to find a cell value from one sheet to another. On Sheet1, I want say "B11" to be what I'm looking for. On Sheet2, I need it to search through say "C1:C5001" and have it select the first one it finds. How would I go about doing that? Thanks |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Find a Cell Value
Or perhaps you just wanted
=match(B11,Sheet2!C$1:C$5001,0) which returns the row in Sheet2!C1:C5001 with the first exact match of B11 on Sheet1 "Bob Tarburton" wrote in message ... Maybe not enough information but it sounds like you want something like =index(Sheet2!B$1:B$5001,match(your_value,Sheet2!C $1:C$5001,0)) If "your_value" is in Sheet2!C11 then the formula returns Sheet2!B11 "Gabe" wrote in message ... Hello, I'm just trying to find a cell value from one sheet to another. On Sheet1, I want say "B11" to be what I'm looking for. On Sheet2, I need it to search through say "C1:C5001" and have it select the first one it finds. How would I go about doing that? Thanks |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
Find a Cell Value
Oh, I'm sorry I forgot to mention that I am trying to do this in code (VBA).
Any suggestions? "Bob Tarburton" wrote: Or perhaps you just wanted =match(B11,Sheet2!C$1:C$5001,0) which returns the row in Sheet2!C1:C5001 with the first exact match of B11 on Sheet1 "Bob Tarburton" wrote in message ... Maybe not enough information but it sounds like you want something like =index(Sheet2!B$1:B$5001,match(your_value,Sheet2!C $1:C$5001,0)) If "your_value" is in Sheet2!C11 then the formula returns Sheet2!B11 "Gabe" wrote in message ... Hello, I'm just trying to find a cell value from one sheet to another. On Sheet1, I want say "B11" to be what I'm looking for. On Sheet2, I need it to search through say "C1:C5001" and have it select the first one it finds. How would I go about doing that? Thanks |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Find & Replace: find part cell, replace whole cell | Excel Worksheet Functions | |||
Find First Non blank cell than find column header and return that value | Excel Worksheet Functions | |||
UDF code to find specific text in cell comments, then average cell values | Excel Programming | |||
find text in a cell and make cell 2 cells below that active | Excel Programming | |||
use find twice to find cell on a specific row | Excel Programming |