Today's author, Dan Battagin, a Program Manager on the Excel team, talks about joining two tables in Excel (a.k.a. returning multiple rows for VLOOKUP). Today, we'll take a look at the VLOOKUP function, and work out a way to get around its major drawback - it returns only a single value that matches the lookup. If you're like me, there are times when you have a big table of data which is pretty well normalized, and you want to pull all of the rows out of that table that match a certain
Read More...
Read the complete post at http://blogs.msdn.com/excel/archive/2008/10/23/creating-a-master-detail-view-in-excel.aspx
Posted
Oct 24 2008, 12:35 AM
by
Microsoft Excel