Forum Discussion
Solved
Use compass directions in two columns to get data in a third
Howdy! In the attached sheet, I'd like to automate the data in f28-33 using what's been input in b28-33 and d28-33. I could use some assistance as I am at my self help limit 🙂 Thanks, Shane
ShaneMellard Not very elegant, but this could work:
=SWITCH(MID(B28,FIND("'",B28)+2,1)&MID(D28,FIND("'",D28)+2,1),"NE","SW","NW","SE","SE","NW","SW","NE")
ShaneMellard Not very elegant, but this could work:
=SWITCH(MID(B28,FIND("'",B28)+2,1)&MID(D28,FIND("'",D28)+2,1),"NE","SW","NW","SE","SE","NW","SW","NE")
Riny_van_Eekelen Thank you very much!
