VLOOKUP with a Boolean membership condition??
 

Hi,
I am trying to modify a VLOOKUP function using a Boolean condition
instead of nesting a bunch of If functions together (and then hitting
the nesting limit of 7). What I would like to do in pseudo code is

IF active cell
is IN (list)
/*I would like this list to behave like standard SQL, i.e. no limit to
the number of variables in list, each item separated by comma*/
Then VLOOKUP(active cell, Range Reference, Column #, false)
Else = 0

Nesting IF statements works until you have more than 7 items in the
list. I would also like to use the same function above with NOT IN
(list) as well. Im not real proficient writing code, but I am amazed
that excel does not have a predefined Is In List function.

Thanks


---
Message posted from http://www.ExcelForum.com/