comparing data, and showing only the true ones

[Pedro_Ramalho]

Hello.
This is an exemple:

I need compare two factors, If A4 = A2 and B4 = B2, if the result of two factors is true - true, show in another table, but only show the true results.

Can help me to solve this problem?
Thks

[#2]

@Pedro_Ramalho Perhaps like this:

File attached.

[#3]

Hi @Pedro_Ramalho 

Not sure how you want in another table, but only show the true results... 

in E4 (Excel 2021/365):

=FILTER(A4:C13, (A4:A13=A2) * (B4:B13=B2))

[#4]

Thks @L z. 

i will try explain.

I have this budget sheet: 
Largura ( width ) x Altura ( height )

and i need check if cutting exist in another BD.

If exist, and we can have more than one with same width and height,
we put the results have the same width and height in the first sheet above the calculations.

[#5 · Accepted solution]

@Pedro_Ramalho 

See new sample attached

[#6]

Fantastic, thats exatly what i need.

THKS SM....

[#7]

Glad I could help