Forum Discussion
Excel formula with if and vlookup ?
JKPieterse yes, they are not the same value but unique: "1" has its specifications but is under same characteristic "X" and "8" has its specifications different from "8", but is under same characteristic "x" as 1.
JKPieterse please see my new table where you can better understand logic and how it should work:
Case tables are what are possibilities that i can have in my sheets, and to the right is fixed table from which there can be readings.
case 1 Table Description Group Description Group Apple 0 Apple Fruit Shoe 0 Pair Fruit Phone 0 Potato Vegetable Airplane 0 Cucamber Vegetable Chainsaw 0 Carrot Vegetable Pencil 0 case 2 Description Group Apple 0 Shoe 0 Phone 0 Airplane 0 Chainsaw 0 Apple 0 case 3 Description Group Apple Fruit Shoe 0 Phone 0 Pair Fruit Airplane 0 Chainsaw 0 Pencil 0 case 4 Description Group Apple Fruit Shoe 0 Phone 0 Pair Fruit Airplane 0 Chainsaw 0 Pencil 0 Apple Fruit case 5 Description Group Apple Fruit Shoe 0 Phone 0 Pair Fruit Airplane 0 Chainsaw 0 Pencil 0 Potato Vegetable Pencil 0 Carrot Vegetable Phone 0 Cucamber Vegetable case 1 - if there is Apple from table but not Pair in table, return 0.
case 2 - if there is Apple repeating but not Pair in table, return 0.
case 3 - in table is Apple and Pair, table should return Fruit
case 4 - in table is Apple repeating but also in table is Pair, table should return Fruit
case 5 - in table is Apple repeating but also in table is Pair, table should return Fruit, but in Table is also other group with same rules, and it returns for Potato, Carrot and Cucumber - Vegetable
The formula in the attached file seems to do what you are looking for. Actually it's two times the same formula connected by the " & " operator. The part of the formula before " & " checks for "Fruit" and the other checks for "Vegetable".
- Thank you very much!
I actually have a big table with around 700 characteristic per different fruits.
do I need to enter for each one formula and " & " ?