Navigating a Table Using a Lookup
I have a need to do some sort of lookup within a table...then navigate to
that point in the table to "look around". I need to navigate because I want to see other surrounding records as well as the retrieved record. Is there any way to do that? Ex: 1 a 3 200 c 2 k 4 400 g 3 e 1 600 i 4 m 7 100 m I want to say I want to look up record 3...then navigate to that point in the table to look around. |
Navigating a Table Using a Lookup
You could use Data-Filter and then establish a custom filter on column A
that filters for a range of values around your target. "BooWeezie" wrote: I have a need to do some sort of lookup within a table...then navigate to that point in the table to "look around". I need to navigate because I want to see other surrounding records as well as the retrieved record. Is there any way to do that? Ex: 1 a 3 200 c 2 k 4 400 g 3 e 1 600 i 4 m 7 100 m I want to say I want to look up record 3...then navigate to that point in the table to look around. |
All times are GMT +1. The time now is 11:20 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com