Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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/ |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Two Condition Vlookup | Excel Discussion (Misc queries) | |||
Membership list | Excel Discussion (Misc queries) | |||
Membership List | New Users to Excel | |||
two condition for vlookup? | Excel Worksheet Functions | |||
Group membership | New Users to Excel |