Site Archives
The Matrix
A while back, one of the guys at work came to me with an Excel problem… He had a matrix of data, and wanted a formula that would, given row and column criteria, return the appropriate value:
I initially thought about combining lookups with IF statements but it got *really* messy. A little digging revealed [...]
Find It Quickly
Find what you're looking for quickly by using our keyword search. Can't find it? Try our links below.
