David Lai's Business Intelligence Blog

Using Filtered Rows instead of VLOOKUP

This article talks about using the filtered rows technique instead of a VLOOKUP. Not until Xcelsius 2008 came out, were we able to filter on multiple rows of data that matched 1 entry. So in order to accomplish this we would either have to use VLOOKUP or INDEX MATCH. Using this technique was very cumbersome and although filtered rows has been available for a while, I have been on a couple engagements...