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.

Duncan Williamson

One Response to “DGET”

  1. […] 28th June 2015: Click this link to go to a tip on the DGET function. The DGET function could well make your VLOOKUP life a lot easier then ever:  […]

Leave a Reply

Fill in your details below or click an icon to log in: Logo

You are commenting using your account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

%d bloggers like this: