Ho do I determine the Active Cell location of the data being sele.
 

I have multiple worksheets. One contains a "Data Entry" routine that looks
up an individual record (based upon a LOOKUP command). I need to know the
"ROW" that contained the results of the LOOKUP command.

Example: =LOOKUP($A$5,'Flight 1'!$B4:$B122,'Flight 1'!E4:E122)

$A$5 = Key Value
'Flight 1'$B4:B122 = Matching Key Value on different worksheet ( Flight 1)
'Flight 1'$E4:E122 = Column "E" holds the value to be returned

How can I determine the ROW that matched the LOOKUP?

Ho do I determine the Active Cell location of the data being sele.
 

The MATCH function is handy for that: plus for the fact that it can do a
match even if the range it is searching is not sorted.

=MATCH($A$5,'Flight 1'!$B:$B,0) gives the row number
=INDIRECT("'Flight 1'!"E" & MATCH($A$5,'Flight 1'!$B:$B,0)) then gives the
lookup value.

"Hibbs" wrote:

I have multiple worksheets. One contains a "Data Entry" routine that looks
up an individual record (based upon a LOOKUP command). I need to know the
"ROW" that contained the results of the LOOKUP command.

Example: =LOOKUP($A$5,'Flight 1'!$B4:$B122,'Flight 1'!E4:E122)

$A$5 = Key Value
'Flight 1'$B4:B122 = Matching Key Value on different worksheet ( Flight 1)
'Flight 1'$E4:E122 = Column "E" holds the value to be returned

How can I determine the ROW that matched the LOOKUP?

Ho do I determine the Active Cell location of the data being s
 

Thank you. I will work with this. I am hoping that I can retrieve the data
in Column E, Update or change it and place it back in its orginal location.
Thoughts on the best way to do this?

Hibbs

"K Dales" wrote:

The MATCH function is handy for that: plus for the fact that it can do a
match even if the range it is searching is not sorted.

=MATCH($A$5,'Flight 1'!$B:$B,0) gives the row number
=INDIRECT("'Flight 1'!"E" & MATCH($A$5,'Flight 1'!$B:$B,0)) then gives the
lookup value.

"Hibbs" wrote:

I have multiple worksheets. One contains a "Data Entry" routine that looks
up an individual record (based upon a LOOKUP command). I need to know the
"ROW" that contained the results of the LOOKUP command.

Example: =LOOKUP($A$5,'Flight 1'!$B4:$B122,'Flight 1'!E4:E122)

$A$5 = Key Value
'Flight 1'$B4:B122 = Matching Key Value on different worksheet ( Flight 1)
'Flight 1'$E4:E122 = Column "E" holds the value to be returned

How can I determine the ROW that matched the LOOKUP?