Help please

[tanke]

Hi all,

I have several worksheets containing data that I would like to exploit, example columns setup as per below.

Worksheet 1

URN LLDRG Date1
111 apple 1/1/2018
123 pear 1/1/2018
222 apple 1/1/2018

Worksheet 2

URN Date2
111 4/2/2018
111 12/2/2018
111 19/2/2018
123 5/2/2018
222 6/2/2018
222 10/2/2018
222 18/3/2018


Worksheet 3

DRG
apple
pear
cherry


I want to compare each item in worksheet 3 'DRG' to Worksheet 1 'LLDRG' and for each matching item take the corresponding Worksheet 1 'URN' , find the matching 'URN' in Worksheet 2 then find the maximum and minimum date.

can someone help? is this possible using a single formula?

thanks,
Brendan

 

[sandy666]

How about PowerQuery ?