Dear Expert,
In my attached file my data table range is A1:D17
column b contains my vlookup criteria & column A,C & D is my criteria range.
column a contains date which is sequence like oldest to newest.
column c & D also contains date but its no sequence, can be same always or same.
In my attached file f3 is my lookup value, i need g3 & h3 result which match column c & d based on lookup value.
if lookup value matches c or d column all data are same then it will take it will take any one or first cell data but if lookup value matched multi date then it will take all date & separe "/".
i3 will lookup value first match data on column A & j3 will lookup value last match data on column A.
In attached file i do it manually which is for your ref. but need it with formula.
Please help me in this regard.
Best Regard
Wahid.
Bookmarks