F
Flamikey
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
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