Yes, Brian, the formula that I presented is somewhat redundant. What you suggested for the redundant formula worked correctly.
Also, the formula you suggested to show what is in D column but not in B column worked correctly. Thank you for the help. Walter On Sun, Oct 25, 2009 at 9:26 PM, Brian Barker <[email protected]>wrote: > 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] > >
