DGET Function-Alternative to Vlookup | Sinokap IT Tech Sharing

Sinokap China IT Service KDB

1

Syntax

=DGET(database, field, criteria)

2

Parameters

database: A range of cells containing the database.

field: The column within the database.

criteria: A range of cells that contain the criteria.

3

Summary

Even though DGET Function is not considered as the most well-known alternative to VLookup, it is simple for you to use under multiple conditions. It basically extracts a single value from a column of a database that matches chosen criteria.

Let's see how it works in Excel~https://v.qq.com/txp/iframe/player.html?width=500&height=375&auto=0&vid=p0907xugx9e

The video is reproduced from the network.

If any infringement, please contact us.

Sinokap offers a full range of IT services to clients in different industry, scale and business nature, including IT on-site service delivery, IT outsourcing services, IT infrastructure services, IT consulting services for end user computing, Server Maintenance, Microsoft service, Linux service, Cisco Network Maintenance and etc. Please feel free to contact us if you have any IT problem.

Please feel free to contact us for any China IT Support requirements. Sinokap Shanghai will provide Professional IT service for you.

如您有任何中国IT服务支持需求，请随时联系我们。Sinokap上海鸿泷信息致力于为您提供专业高效的IT服务。

Contact Us

E-mail:       [e-mail]:       [phone]Website:      www.sinokap.comSinokap ∣ We Make IT Simple!长按，识别二维码，加关注