I use DGET Function to lookup some values and get the corresponding values from an excel table. The criteria range in D2 is C1:C2, in D3 it is C1:C3, in D4 it is C1:C4 and so on.
I want only the first cell and the last cell in the criteria range. Eg: C1 and C4 only in C1:C4. Is that possible?
I tried with (C1:C4)-(C2:C3), but it doesn't work.
Last edited by ajeshkdy; 08-08-2019 at 03:25 PM.
Use If Condition.
Please attach a worksheet with sample data and expected Result.
To attach worksheet Go advanced -> Manage attachments -> Choose file -> Upload
Don't forget to Mention your desired result in the sheet..
There should be sample data only, a lot of data creates confusion.
Thanks & Regards
Shivya
http://excelvbatipsforbeginners.blogspot.in/
Hi,
I have attached a sample file. Please check it.
Thanks.
Try pasting the following formula into cell D2 on the Key D sheet:Formula:
Please Login or Register to view this content.
After pasting drag the fill handle down to D8.
Let us know if you have any questions.
Consider taking the time to add to the reputation of everybody that has taken the time to respond to your query.
Actually I was able to reach to this code after a long google search and some tweaks as I didn't get the code from here. However, I appreciate your effort. As this code works, I am changing the status of the thread to solved.
Thank You for the feedback and for marking the thread as 'Solved'. I hope that you have a blessed day.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks