multiple cell value to find match in range

Hello,
I have problem to find formula to show row in which specific cell value must include .
let me say if cell value 0,9and 7 of A56:C56 to find which row have included all these 3 number in range A1:D54.
in sample sheet, row23 must return result true because all 0,9 and 7 were completed.
I am sorry for my english if can;t make clear describe the problem.

Thank you zbor,
I've tried your formula but result is different what i expected.
I'd like to see the row which has all these three number 7,9 and 0 together.
in row 23, there is 7,8,9and 0 ,so should return true.
same thing in row 30, there 5,7,9 and 0 together, so should return true also.
wherein row which 7, 9 and 0 included, (assume double number also), to return result true.
anyway thanks you for your effort.
regards

Originally Posted by nflsales

Row No 19 have values 9,0,3,7
Why it is not True?

Hi nflsales,
Yes, row 19 also true.
I just point out that example in row 23 and 30.
I learnt your answer on other post regarding counting number using sumproduct and right formula.
Can you help my problem here?

Originally Posted by nflsales

If that is the case @ zbor formula

Please Login or Register  to view this content.

in post 2 will work

=SUMPRODUCT((COUNTIF(A2:D2, {0,7,9})>0)+0)>2

Oh.... thats work.

Thank you Zbor and nflsales .
you are my guru.
I have to learn a lot and before mark as a solved, I will be pleased if you explain how you create formula and thinking .
Just request only in brief.(i know you all were busy helping ppl)
because I really not know symbol { } .part of array formula?
Thank you very much.
best regards,
tin