Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Extracting information from table
Hi
I have a table as follows blue green yellow 4 jane heidi natalie 3 bruce sharon fred 2 sally paul Ken 1 brendon kevin graham (excuse the layout but you'll get the idea). I want to put a formula in another worksheet than includes blue and 2 (being the column and row headers) and get 'Salley" returned being the contents of the cell at the intersection of the named column and row. Can someone point me in the right direction - I've tried DGet and Index but they don't work as I need them to (unless I'm missing something" Thanks IanB |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
extracting information from a certain place in one cell | Excel Discussion (Misc queries) | |||
Extracting information from large worksheet | Excel Worksheet Functions | |||
Extracting Information from A Pivot Table | Excel Discussion (Misc queries) | |||
Extracting certain information from cells | Excel Worksheet Functions | |||
Extracting information from records to another sheet automatically | Excel Worksheet Functions |