Automatically insert arguments from list to function
Hello,
I have an AND / OR function in which I have at least 12-15 arguments in the form of
OR(B5="0439";B5="0535";B5="0536";B5="0567";B5="0811";B5="0898";B5="0923";B5="0936";B5="0941";B5="095 7";B5="0972")
The arguments changes frequently and every time, I have to change them manually. I have the statements in a list in the form of
0439
0535
0567
etc
Is there any way that I can "feed" the function automatically from the list.
I have some basic Macro self-taught experience, so if there is a macro invlolved I can try it.
Thank you
If you have a list, you could just use COUNTIF or VLOOKUP to check if the cell contents is in the list.
For example:
=IF(COUNTIF(ListRange,B5)>0,"Found","Not Found")
Regards
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Reply With Quote
Bookmarks