Sure thing. Here is a link to the file I was using: 1drv.ms/x/s!As18kgro1XNs-cYlSXNakxAyvl6z5A The link is a view only link, but you can save a copy of it to your OneDrive for editing.
DGET offers unique advantages in specific situations. Advantages of DGET: Simplified syntax for single-criteria lookups: DGET can be more concise than XLOOKUP or VLOOKUP when you're searching based on a single criterion. You essentially define a database area, the column to return data from, and the criteria for your search. Handles multiple criteria easily: DGET excels when you need to find a match based on multiple conditions. This is more complex to achieve with VLOOKUP and requires intermediate steps with XLOOKUP. Database-centric approach: If your data is structured like a database (with clear headers and records), DGET aligns well with this format.
Awesome video!
So Nice video❤
Thanks
Perfect 👍 please also share data file for practice.
Sure thing. Here is a link to the file I was using: 1drv.ms/x/s!As18kgro1XNs-cYlSXNakxAyvl6z5A
The link is a view only link, but you can save a copy of it to your OneDrive for editing.
XLook-up will do magic. Is there any advantage over vlook ot xlook?
yes there is try vlookup(array, {3,2,1},false) it will return 3 columns in reverse order.
DGET offers unique advantages in specific situations.
Advantages of DGET:
Simplified syntax for single-criteria lookups: DGET can be more concise than XLOOKUP or VLOOKUP when you're searching based on a single criterion. You essentially define a database area, the column to return data from, and the criteria for your search.
Handles multiple criteria easily: DGET excels when you need to find a match based on multiple conditions. This is more complex to achieve with VLOOKUP and requires intermediate steps with XLOOKUP.
Database-centric approach: If your data is structured like a database (with clear headers and records), DGET aligns well with this format.