Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
DiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWord
DirectoryUser Groups
Related Topics
Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ...

MS Office Forum / Excel / Worksheet Functions / March 2007

Tip: Looking for answers? Try searching our database.

Extracting information from table

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
Ianb - 07 Mar 2007 21:11 GMT
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
Toppers - 07 Mar 2007 22:12 GMT
This is exactly what INDEX does:

=INDEX(B2:D5,match(2,$A$2:$A$5,0),"Blue",$B$1:$D$1,0))

Assuming your table including headers is in A1:D5

HTH

> Hi
> I have a table as follows
[quoted text clipped - 15 lines]
>
> IanB
T. Valko - 07 Mar 2007 22:13 GMT
With you table in the range A1:D5

B1:D1 = column headers
A2:A5 = row headers

A10 = lookup value = blue
A11 = lookup values = 2

=VLOOKUP(A11,A1:D5,MATCH(A10,A1:D1,0),0)

result = sally

Biff

> Hi
> I have a table as follows
[quoted text clipped - 18 lines]
>
> IanB
 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread
Enable EMail Alerts
Rate this Thread



©2008 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.