Results 1 to 7 of 7

Difficulty using a function with words(2)

Threaded View

  1. #1
    Registered User
    Join Date
    02-08-2015
    Location
    Clinton TWP, MI
    MS-Off Ver
    2007
    Posts
    15

    Unhappy Difficulty using a function with words(2)

    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!
    Last edited by mspad33; 02-08-2015 at 03:25 PM. Reason: Title

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. figuring out a percentage function
    By ryankelley318 in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 10-29-2014, 04:04 PM
  2. Close to function
    By wolverineandrew in forum Excel General
    Replies: 5
    Last Post: 10-14-2010, 07:09 PM
  3. IF function to find no close to?
    By mister tom in forum Excel General
    Replies: 3
    Last Post: 11-20-2009, 02:20 PM
  4. figuring out which function to use for this scenario.
    By Kalamingo in forum Excel General
    Replies: 1
    Last Post: 05-14-2008, 12:00 PM
  5. [SOLVED] Figuring daily average...function ???
    By Fish in forum Excel Formulas & Functions
    Replies: 7
    Last Post: 03-10-2006, 01:30 PM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1