Vlookup returns the value of the cell. How do I make so that it returns the row # of the cell?
J J@Y Feb 9, 2007 #1 Vlookup returns the value of the cell. How do I make so that it returns the row # of the cell?
J J@Y Feb 9, 2007 #4 =Row needs a cell as input, Vlookup outputs a string value Dave F said: =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 said: Vlookup returns the value of the cell. How do I make so that it returns the row # of the cell? Click to expand... Click to expand...
=Row needs a cell as input, Vlookup outputs a string value Dave F said: =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 said: Vlookup returns the value of the cell. How do I make so that it returns the row # of the cell? Click to expand... Click to expand...
