Find value from a search list in a cell ( Excel Formula; Sumif, sumproduct etc )

user8oxG 0
Viewed 33

I have a question as below:

I have a list of numbers in a different sheet ( INFO) in a column for example H:H:

Includes?
59701
59702
59744
59761
59774
59817

... and I have a details in different sheet (DB) at U:U:

3*58.00  Std - 7*17.40 N59020:
2*72.00 : Std - 7*21.60 N59020:
7*72.00 : Std - 7*21.60 N59020:
5*100.00 N59872:
71*100.00 N59872:

I write a formula in DB column "Z2":

=IF(SUMIF(U2;"*59701*")>0;"Yes";
    IF(SUMIF(U2;"*59702*")>0;"Yes";
       IF(SUMIF(U2;"*59744*")>0;"Yes";"No") ...

My question is top formula need to define all search details, I need to repeat every number that includes at search Info.

Is there a way to define this Info search list, in order not to repeat the formula for every different number?

Thank you for your supports and sorry for my English.

formula search if-statement excel
1 Answers

I found the answer,just sharing;

=IF(OR(COUNTIF(U2;Info!$I$2:$I$28));"Yes";"")

In column I:I i made formula to add wildcharacter "*"; for example now search become --

59701

thank you for all for helping :)

user8oxG0
Related