ExcelBanter - Use Vlookup or similiar function to find the row of the target cel

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - Use Vlookup or similiar function to find the row of the target cel (https://www.excelbanter.com/excel-discussion-misc-queries/130066-use-vlookup-similiar-function-find-row-target-cel.html)

J@Y

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?

Dave F

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?

Toppers

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?

J@Y

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?

All times are GMT +1. The time now is 06:48 PM.