|
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 |