Learn Excel Episode 1170: Concatenated Lookup? 1171 - Learn Excel from MrExcel
Another look at Formula Speed in Excel: I have to do a lookup to find both a city and a day. Rather than using a concatenated lookup, two alternative formulas that perfom faster.Episode 1170 Episode 1170 shows you how....