| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Use Vlookup or similiar function to find the row of the target cel
Vlookup returns the value of the cell. How do I make so that it returns the
row # of the cell? |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Use Vlookup or similiar function to find the row of the target cel
=ROW(VLOOKUP([your vlookup]))
Dave -- A hint to posters: Specific, detailed questions are more likely to be answered than questions that provide no detail about your problem. "J@Y" wrote: Vlookup returns the value of the cell. How do I make so that it returns the row # of the cell? |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Use Vlookup or similiar function to find the row of the target cel
Look at MATCH function as an option.
"J@Y" wrote: Vlookup returns the value of the cell. How do I make so that it returns the row # of the cell? |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Use Vlookup or similiar function to find the row of the target
=Row needs a cell as input, Vlookup outputs a string value
"Dave F" wrote: =ROW(VLOOKUP([your vlookup])) Dave -- A hint to posters: Specific, detailed questions are more likely to be answered than questions that provide no detail about your problem. "J@Y" wrote: Vlookup returns the value of the cell. How do I make so that it returns the row # of the cell? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Embedded If Function in a Vlookup Function | Excel Worksheet Functions | |||
| Find Function | Excel Discussion (Misc queries) | |||
| numerical integration | Excel Discussion (Misc queries) | |||
| Advance Vlookup function may help!! | Excel Worksheet Functions | |||
| VLOOKUP Function | Excel Discussion (Misc queries) | |||
Linear Mode
