| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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? |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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? |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How to determine the cell location? | Excel Worksheet Functions | |||
| Show value from specific column based on location of active cell | Excel Discussion (Misc queries) | |||
| Move active cell to same location on each worksheet | Excel Discussion (Misc queries) | |||
| use active cell to determine range | Excel Discussion (Misc queries) | |||
| On Opening Excel WB the Active cell location never changes | Excel Discussion (Misc queries) | |||
Hybrid Mode
