Sample included.
In C2, I need a formula that looks at B2, compares it to the table in E:F, and returns an 'X' if the value is 3 or bigger, otherwise, enter nothing.
In my primitive programming mind, I 'wanted' to do something like:
=if(lookup(B2,$E$2:$F$6>2),"X","")
I had a similar solution I was helped with -- used a sumproduct function, which worked great. This one is a little different as it checks a condition, then returns a different value.
I could solve my issue by entering another column that first performs the lookup, returns the value, and then use an if function to return "X" from that new column, but I figure there has to be a way to avoid an extra formula and take two steps at once.
Thanks for your help.
Bookmarks