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?