VLOOKUP combined with OR - help!

[Bilingual]

Hi i have a huge problem, i am using LOOKUP to look up a whether a value is found in a table

The setup is a lookup in [@[From adress]] to check whether the value is found in Table10, which works fine.

However when i add the FALSE value to lookup in in [@[To adress]] to check if the value is found in Table10, it does not return the correct value for [@[To adress]], even when the value can not be found in Column1.

I have tried with adding OR to no avail, could someone please help me?


=IFERROR(IF(VLOOKUP([@[From adress]];Tabel10;1;FALSE)=[@[From adress]];[@[Sum]];IF(VLOOKUP([@[To adress]];Tabel10;1;FALSE)=[@[To adress]];[@[Sum]];0));0)

 

[Worf]

Hi

Can you post some sample data, explaining what are the expected results?
In what row are you entering the formula?

[TABLE="width: 768"]
<tbody>[TR]
[TD]#This Row
or
@
or
@[Column Name][/TD]
[TD]Just the cells in the same row as the formula. These specifiers can’t be combined with any other special item specifiers. Use them to force implicit intersection behavior for the reference or to override implicit intersection behavior and refer to single values from a column.
Excel automatically changes #This Row specifiers to the shorter @ specifier in tables that have more than one row of data. But if your table has only one row, Excel doesn’t replace the #This Row specifier, which may cause unexpected calculation results when you add more rows. To avoid calculation problems, make sure you enter multiple rows in your table before you enter any structured reference formulas.[/TD]
[/TR]
</tbody>[/TABLE]