# 2 WAY LOOKUP IN EXCEL

Crispo Mwangi | 20-Aug-16 | 2 CommentsThe ability to lookup values is a MUST have skills for all Excel users. If you cannot lookup you cannot excel in data analysis. In this article, I will show you 5 ways you can do a 2-way lookup in Excel. 1. USING SUMPRODUCT Using below sales data lookup and sum the total quantity for ALL items ordered […]