How do I return the row for a value I VLOOKUP?
 

I have a spreadsheet I am returning various variables from. When it returns
a value I would like to in a separate cell have a formula that tells me what
row that value came from. I can't seem to write the formula correctly. I am
assuming I need to some how nest the ROW function with the VLOOKUP function.
Is this possible? Here is my current formula:

=VLOOKUP($B6,'Loan Disbursement Summary'!$I$2:$BV$8477,3,FALSE)

Where does the ROW function belong in this mix?

How do I return the row for a value I VLOOKUP?
 

Since your lookup table starts in row 2, use

=match($B6,'Loan Disbursement Summary'!$I$2:$BV$8477,0)+1

"fryerfarm" wrote:

I have a spreadsheet I am returning various variables from. When it returns
a value I would like to in a separate cell have a formula that tells me what
row that value came from. I can't seem to write the formula correctly. I am
assuming I need to some how nest the ROW function with the VLOOKUP function.
Is this possible? Here is my current formula:

=VLOOKUP($B6,'Loan Disbursement Summary'!$I$2:$BV$8477,3,FALSE)

Where does the ROW function belong in this mix?

How do I return the row for a value I VLOOKUP?
 

=MATCH($B6,'Loan Disbursement Summary'!$I$2:$I$8477,0)+1


--

HTH

RP
(remove nothere from the email address if mailing direct)


"fryerfarm" wrote in message
...
I have a spreadsheet I am returning various variables from. When it
returns
a value I would like to in a separate cell have a formula that tells me
what
row that value came from. I can't seem to write the formula correctly. I
am
assuming I need to some how nest the ROW function with the VLOOKUP
function.
Is this possible? Here is my current formula:

=VLOOKUP($B6,'Loan Disbursement Summary'!$I$2:$BV$8477,3,FALSE)

Where does the ROW function belong in this mix?