i am using the If function, but i wish to expand the logical test criteria.
I had three names that the cell could not equal, and previously did this by
using three *AND(not = to)* instructions. Now however this has expanded to
over a hundred names that i want the target to not equal.
short of writing out 100 more AND commands in the if function how can i
achieve this?
The list of names i want to exclude are in the same excel file - could i
perhaps link the if function to the table?

any help greatly appreciated
thanks

Hi

Use VLOOKUP for this. See
http://www.contextures.com/xlFunctions02.html

HTH. best wishes Harald

"arran1180" skrev i melding
...
i am using the If function, but i wish to expand the logical test
criteria.
I had three names that the cell could not equal, and previously did this
by
using three *AND(not = to)* instructions. Now however this has expanded to
over a hundred names that i want the target to not equal.
short of writing out 100 more AND commands in the if function how can i
achieve this?
The list of names i want to exclude are in the same excel file - could i
perhaps link the if function to the table?

any help greatly appreciated
thanks