Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
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. |
#2
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
navigating between worksheets | Excel Worksheet Functions | |||
Navigating Excelbanter | Excel Discussion (Misc queries) | |||
navigating between worksheets | Excel Discussion (Misc queries) | |||
Pivot table doing a lookup without using the lookup function? | Excel Discussion (Misc queries) | |||
Navigating | Excel Discussion (Misc queries) |