Row # 1

[gmoorthy]

Is it possible to get the row# which the basic excel template has if i can compare a value in the specific column for ex :

ColumnA
1 ABC
2 XYZ


Where 1 and 2 are the row#'s which you see at the side when you open a excel template. I have another spreadsheet which has the values ABC and XYZ and would like to do a vlookup and then pick the row#

 

[kjv1611]

Have you tried using the Row() function within your formula?

http://www.techonthenet.com/excel/formulas/row.php

http://www.ozgrid.com/Excel/sum-every-2nd-nth-cell.htm

This might specifically help you, not sure:

http://www.techonthenet.com/excel/formulas/vlookup.php

Search for Row, or just browse down a little bit, it's few secions down, but it talks about using the Row() function within your vlookup() function.

In part:

Question: Is there a simple way in Excel to VLookup the second match in a column? So, for instance, If I had apple, pear, apple listed in the column (each word in a separate cell), would there be a way to look up the values to the right of the second "apple"?

Answer: This can be done with a formula that utilizes a combination of the Index function, Small function, Row function (all in an array formula).

 

[SkipVought]

Hi,

If you have in Sheet1'''
[tt]
ColumnA
ABC
XYZ
[/tt]
and in Sheet2...
[tt]
ColumnA
XYZ
ABC
[/tt]
in Column B
[tt]
=MATCH(A1,Sheet1!A:A,0)
[/tt]



Skip,

_{Just traded in my old subtlety...
for a NUANCE!}