View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Ianb Ianb is offline
external usenet poster
 
Posts: 9
Default 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