see the attached file
i want a formula in column C
if there is 1,10,11,22,36,32 then south if 5,6,12,13,33,34 then west, if 7,4,19,20,24,27
see the attached file
i want a formula in column C
if there is 1,10,11,22,36,32 then south if 5,6,12,13,33,34 then west, if 7,4,19,20,24,27
=IF(OR(A1=1,A1=10,A1=11,A1=22,A1=36,A1=32),"South",IF(OR(A1=5,A1=6,A1=12,A1=13,A1=33,A1=34),"West",IF(OR(A1=7,A1=4,A1=19,A1=20,A1=24,A1=27),"North","")))
Try
=IF(A1="","",VLOOKUP(A1,{1,"SOUTH";10,"SOUTH";11,"SOUTH";22,"SOUTH";36,"SOUTH";32,"SOUTH";5,"WEST";6,"WEST";12,"WEST";13,"WEST";33,"WEST";34,"WEST";7,"NORTH";4,"NORTH";19,"NORTH";20,"NORTH";24,"NORTH";27,"NORTH"},2,0))
If I helped, Don't forget to add reputation (click on the little star ★ at bottom of this post)
Don't forget to mark threads as "Solved" (Thread Tools->Mark thread as Solved)
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks