At 20:35 25/10/2009 -0600, Walter Hildebrandt wrote:
In a cells of a column the following formula is entered.
IF(ISNA(VLOOKUP(D4;$B$4:$B$200;1;0));"";VLOOKUP(D4;$B$4:$B$200;1;0))
This formula produces all the entries that are in both the B column
and the D column.
That is somewhat redundant. In the case that the condition is false,
the look-up will have been successful, and the VLOOKUP() will have
found a copy of D4 somewhere in column B. This means that the value
of the VLOOKUP() will be the same as whatever is in D4. So this reduces to:
=IF(ISNA(VLOOKUP(D4;$B$4:$B$200;1;0));"";D4)
What formula would produce only the entries that are in the D column
but *not* in the B column
There are various possibilities. To test if the VLOOKUP() does not
return #N/A, just reverse the test using the NOT() function:
=IF(NOT(ISNA(VLOOKUP(D4;$B$4:$B$200;1;0)));"";D4)
Alternatively, you could just reverse the choices of result:
=IF(ISNA(VLOOKUP(D4;$B$4:$B$200;1;0));D4;"")
I trust this helps.
Brian Barker
---------------------------------------------------------------------
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]
