CODEWITHSUNDEEP
arraysgoogle-sheetsfiltergoogle-sheets-formulagoogle-sheets-query
J. Kenneth Reátegui B.
J. Kenneth Reátegui B.

Reputation: 27

Common value in 2 groups of values with Google Sheets

I have alphanumeric values in 2 groups of values, on 2 different tabs:

enter image description here

I have the A value and the G value, and I need the value associated with each of them that is repeated in both groups (D). Someone who dominates QUERY maybe can help me.

Upvotes: 1

Views: 70

Answers (1)

player0
player0

Reputation: 1

try:

=FILTER({A2:B; D2:E}, COUNTIF({B2:B; D2:D}, {B2:B; D2:D})>1)

0

UPDATE:

=ARRAYFORMULA(IFNA(VLOOKUP(B1&C1, QUERY({'Page 1'!A2:A&
 IFNA(VLOOKUP('Page 1'!C2:C, 'Page 2'!C2:D, 2, 0)),
 IFNA(VLOOKUP('Page 1'!C2:C, 'Page 2'!C2:D, 1, 0))}, 
 "where Col2 is not null", 0), 2, 0)))

0

Upvotes: 1

Related Questions