IntroductionGetting StartedAll PostsNotesAbout The Author
Two-Dimensional Lookups And Lookups With Mutliple Inputs
Friday, July 31, 2009 - 2:53 PM

If you have ever wanted to lookup a value from a table using input values for both the row and column, you may have found or created a formula that uses both the Index and Match worksheet functions. There is a another way to do it though, which is better in most cases.

See this link: http://support.microsoft.com/kb/275170. Not only does using data labels allow you to create two-dimensional lookups, you can even use multiple inputs for each of those dimensions!

<< Navigate to Friday, July 31, 2009 Add New Comment
No records found        
Add New Comment
Your name   
Subject   
Content   
*Required fields

January, 2009
February, 2009
March, 2009
April, 2009
May, 2009
June, 2009
July, 2009
August, 2009
September, 2009
October, 2009
November, 2009
December, 2009
IntroductionGetting StartedAll PostsNotesAbout The Author