Hi
Need some help on below:-

I will like the results to return as below based on raw data in spreadsheet
2..
how can i achieve this? the formulas i'm using returns the duplicate IDs in
rows if it appears more than once in spreadsheet 2

Using the formula, "INDEX('Closed To Date'!$A$1:$J$9926,SMALL(IF('Closed To
Date'!$A$1:$A$9926=$C$4,ROW('Closed To Date'!$A$1:$A$9926)),ROW(3:3)),10)"
the results return
ID Lic Mnt
1234 $10 $25
1234 $10 $25
4567 - $50

Desired results:-
Spreadsheet 1: Owner = ABC
Return the results only for owner ABC in below format:-
ID Lic Mnt
1234 $10 $25
4567 - $50

Spreadsheet 2:
Owner Values ID Product
ABC $10 1234 Lic
ABC $50 4567 Mnt
EFD $60 4569 Mnt
EFD $50 7893 mnt
GCH $30 2456 Mnt
GEH $20 5647 mnt
EFH $35 2434 mnt
ABC $25 1234 Mnt

Thanks, any help is appreciated!
--
nikko