This is just a tip but I might well turn it into a full page … let me know what you think.
Like many people I have spent a lot of time using and worrying about the VLOOKUP function and whether it can read right to left as well as left to right.
Well, I have been thinking about this and have been playing with the DGET function and it can do in a very simple way.
I have used a couple of simple examples for you to consider and the screenshot below shows them. Take a look and see what you think. If you have been sweating over right to left VLOOKUP maybe those sweating days are over!
(click on the image to see the full size version)
There is no file to download as I have given you everything you need in that screenshot but if you want a larger set of examples to consider let me know and I will look at DGET, DSUM, DMIN and DMAX too.