DGET

[mcleod15]

I am trying to convert a lotus spreadsheet to Excel. Having a difficult time converting this formula into an equivalent Excel Formula.


@DGET($SRV CHG TABLE 2,"rate",INOUT=H93#AND#SERVICE="W"#AND#METER=H91)

H93=I
H91=5/8 inch.

Any help would be much appreciated. Thanks.

 

[Norie]

Can you explain what this formula does?

Is it looking up values?

 

[Zack Barresse]

You just need to change out for your ranges.


=DGET(DatabaseRange,"rate",CriteriaRange)


Note that your CriteriaField also need column headers along with your DatabaseRange. I wonder if "rate" needs capatilized? Is that how your column headings are labeled?


Norie: "Is it looking up values?" That is what DGET does.

 

[Norie]

firefytr

I know DGET in Excel looks up values and I imagine it does the same in Lotus, I just wasn't sure they worked in the same way.