Hi,
A table contains these values:
Name Quantity 1 Quantity2
BOOK 1 ........... 20 0
BOOK 2 ................. 4 0
A12345 ............... 34 5
G45677 .................. 3 4
901020 ................ 34 5
FRUIT ................. 34 0
DISK .................. 123 0
H12497 .............. 3 3
The formula should be:
1) create a table (table1) containing ONLY values (A12345, G45677, H12497)
please note that table contains hundreds of values and it's impossibile to list them
2) create a new formula
if Name is equal to one of those present in the table1, (quantity1 + quantity2), quantity1
