All articles with '2d lookup' Tag
{ 40 Comments }
Looking up when the data won’t co-operate (case study)
Published on Nov 4, 2014 in Excel Challenges, Excel Howtos
Occasionally we deal with data that is so uncooperative that we might as well give up and go back to calculators & ledger books.
Recently I found myself in such a situation and learned something new.
Introducing … data that won’t play nice
Drum roll please. Here is a data-set that I got from somewhere.
The problem – build a lookup formula
And the problem. Oh, simple. Write a lookup formula to find how many customer walk-ins we have on any given day.
But how?
Continue »
