Home |
Search |
Today's Posts |
#1
|
|||
|
|||
find formula that will look up a value in a specific column and .
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? |
#2
|
|||
|
|||
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 HIS "ksgirl89" wrote in message ... 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? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
column to row in formula | Excel Worksheet Functions | |||
what formula do i put for column m = column k minus column l in e. | Excel Discussion (Misc queries) | |||
how do I find an average number of specific words in a column | New Users to Excel | |||
how to enter a formula using column() function for a range | Excel Worksheet Functions | |||
Formula to reference column heading | Excel Worksheet Functions |