Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Reference the top line of a filtered list
I want to be able to reference the top line of a filtered list with the
intention of using it in a vlookup function in another cell. For example, if col A has a list of tutor groups R1, R2, R3 etc... and I have a vlookup to match the tutor group to a person, when I filter by tutor group the persons name is displayed in this other cell. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
A list of what is being filtered on? | Excel Discussion (Misc queries) | |||
How to combine two list on one reference line Excel 2003 | Excel Discussion (Misc queries) | |||
Totalling up a Filtered List | Excel Worksheet Functions | |||
creating a filtered list | Excel Discussion (Misc queries) | |||
How do I reference an Excel filtered list in a function? | Excel Worksheet Functions |