Forum Discussion
HELP PLEASE!
I need to figure out how to create a formula that will do the following: If the number entered in, lets say, A3 is 8> AND 12<, then the number "3" is returned. If the number entered in A3 is 12> AN...
Could you please revise the title of your post so that it better reflects your challenge (everybody who come here expect help) - Thanks
=XLOOKUP(A3,{8,12,16,20,24,28},{3,4,5,6,7,"Outside"},"Outside",-1)