I am looking for a formula that will find a certain text value (open) in a
column (J) and pull that row (or row #) to a new sheet. Does anyone know if
there is a way to do that?
I am looking for a formula that will find a certain text value (open) in a
column (J) and pull that row (or row #) to a new sheet. Does anyone know if
there is a way to do that?
Ksgirl
Providing the data starts in J1 the formula below will return the row
number. Bear in mind that a formula can only return a value, not move data.
You may also be looking for a VLOOKUP, it was just the way your question was
phrased that made me return a row number
=MATCH("Open",Sheet1!J:J,0)
--
HTH
Nick Hodge
Microsoft MVP - Excel
Southampton, England
[email protected]HIS
"ksgirl89" <[email protected]> wrote in message
news:[email protected]...
>I am looking for a formula that will find a certain text value (open) in a
> column (J) and pull that row (or row #) to a new sheet. Does anyone know
> if
> there is a way to do that?
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks