Try Chip Pearson's left lookup formula at

http://www.cpearson.com/excel/lookups.htm#LeftLookup



"GoBobbyGo" wrote in message
...
You can use other formulas to get the same result as most of the D
functions

I know I can use vlookup in some situations and sumif in others, but
neither
of them allows me to refer to a column header by name. I guess I could
get
around it with named ranges and the indirect() function I just learned
about,
but that's pretty cumbersome too. VLOOKUP doesn't seem to work if the
information I need is to the left of the identifier column.

Or did you mean other formulas? If so, which?

I assume the D functions are there because Lotus had them
Yes, I need to convert a whole bunch of spreadsheets from 1-2-3 to Excel

"Peo Sjoblom" wrote:

You can use other formulas to get the same result as most of the D
functions, I assume the D functions are there because Lotus had them

--

Regards,

Peo Sjoblom

"GoBobbyGo" wrote in message
...
Why do DGET, DSUM, etc require a range as the criteria, and one that
must
be
at least 2 cells high, at that.

I've got a whole chart of things that need to call on these functions
and
the one-row-mapping-into-two thing is NOT helpful.

Yes, yes, I get it, I can stick side-by-side columns off to the side
somewhere and get around it, but it's unbelievably cumbersome.

Why can't I, instead of having to use a range as criteria, just
specify it
right in the function?