Hi guys,
Please explain me what am I doing wrong with the following situation:
I have two tables, in both tables I have sim card numbers and according contact addresses. The reason why I need two tables is that in one of those tables, addresses are more fresh but the problem is that not every sim card number has the more fresh address therefore I have to use less fresh address or the address from first table. Because VLOOKUP would give me either: address from the fresh table, zero as there is no address indicated for that number or N/A as sim card numbers may very well be only in one table I have written this formula that does not work:
[TABLE="width: 259"]
<tbody>[TR]
[TD="width: 259"] =IF(OR(VLOOKUP(sim_number;fresh_table;2;0)=0;ISERROR(VLOOKUP(sim_number;fresh_table;2;0)));value from old table;VLOOKUP(A2;fresh_table;2;0))
Evaluating the formula I can see that the problem technically is with the fact that OR statement takes N/A as the results and therefore IF statement doesn't understand what to do and gives yet another N/A but I don't get it why this happens if I have an OR statement that needs only one TRUE value and even if both of those values would be FALSE then IF statement would go further, to the part of "if not true".
I would really appreciate the help[/TD]
[/TR]
</tbody>[/TABLE]
Please explain me what am I doing wrong with the following situation:
I have two tables, in both tables I have sim card numbers and according contact addresses. The reason why I need two tables is that in one of those tables, addresses are more fresh but the problem is that not every sim card number has the more fresh address therefore I have to use less fresh address or the address from first table. Because VLOOKUP would give me either: address from the fresh table, zero as there is no address indicated for that number or N/A as sim card numbers may very well be only in one table I have written this formula that does not work:
[TABLE="width: 259"]
<tbody>[TR]
[TD="width: 259"] =IF(OR(VLOOKUP(sim_number;fresh_table;2;0)=0;ISERROR(VLOOKUP(sim_number;fresh_table;2;0)));value from old table;VLOOKUP(A2;fresh_table;2;0))
Evaluating the formula I can see that the problem technically is with the fact that OR statement takes N/A as the results and therefore IF statement doesn't understand what to do and gives yet another N/A but I don't get it why this happens if I have an OR statement that needs only one TRUE value and even if both of those values would be FALSE then IF statement would go further, to the part of "if not true".
I would really appreciate the help[/TD]
[/TR]
</tbody>[/TABLE]