The expression will take care of that, via the 2 MATCHes. The order of the lookup data, eg Cats is immaterial. Same goes for the month col header eg April, ie you could easily copy the formula to return more than a single month's worth of results
The expression will take care of that, via the 2 MATCHes. The order of the lookup data, eg Cats is immaterial. Same goes for the month col header eg April, ie you could easily copy the formula to return more than a single month's worth of results
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks