I have a vlookup, wild card search question. I have a table array called project table with values:
14824
14002
14151
14447
14360
14240
14571
and an input table:
14962
14824, 14892, 14571, 14457, 14762
14471
14571
14052, 14151, 14278
14824
14002
And I used the following vlookup code to tell me if any of the values in the input table is in the project table.
=VLOOKUP("*"&A2&"*",Project Table!A2:A8, 1, FALSE)
It gives me the right answer if the cell only has one value. if it has multiple values it gives me a 'False'.
I just want it to give me a true or false indication. To be clearer, I would like the input table to give me a true indication as one of the input projects value is in the project table.
Can you please help me?
Thanks
Will
14824
14002
14151
14447
14360
14240
14571
and an input table:
14962
14824, 14892, 14571, 14457, 14762
14471
14571
14052, 14151, 14278
14824
14002
And I used the following vlookup code to tell me if any of the values in the input table is in the project table.
=VLOOKUP("*"&A2&"*",Project Table!A2:A8, 1, FALSE)
It gives me the right answer if the cell only has one value. if it has multiple values it gives me a 'False'.
I just want it to give me a true or false indication. To be clearer, I would like the input table to give me a true indication as one of the input projects value is in the project table.
Can you please help me?
Thanks
Will