Insert a function in the cell H11 that looks up the sales rep region based on the table in cells E2:F6. E3 reads 10 then F3 is East Coast, E4 reads 20 then F4 is Mid West, E5 reads 30 then F5 is West Coast, E6 reads 40 then F6 reads International. The region codes are shown in G11 through G23. I am so close with this one because it worked with 90% of them but not all of them. The function I used is =LOOKUP(G11,E3:F6)
If you could help me that would be great, Thank you!
Bookmarks