+ Reply to Thread
Results 1 to 3 of 3

VLOOKUP not working

  1. #1
    Registered User
    Join Date
    05-09-2007
    Posts
    4

    VLOOKUP not working

    Hi guys,
    Newbie here! Trying to figure out why my VLOOKUP for this formula is not working. Not sure if I am using the correct logical formula or maybe missing a parenthesis? Tried IF(AND... func but didnt work or maybe I did it wrong

    Im sure you Guru's can help me. Thanks!

    Arguements:
    IF(G3299="AX","Per Diem"
    IF(F3299=64,IF(G3299="AP","PT Sales",
    IF(F3299=64,IF(G3299="AF","Sales"),
    VLOOKUP(F3299,Jobs,2,FALSE)

    Formula:
    =IF(G3299="AX","Per Diem",IF(F3299=64,IF(G3299="AP","PT Sales",IF(F3299=64,IF(G3299="AF","Sales"),VLOOKUP(F3299,Jobs,2,FALSE)))))

  2. #2
    Forum Expert daddylonglegs's Avatar
    Join Date
    01-14-2006
    Location
    England
    MS-Off Ver
    2016
    Posts
    14,675
    I'm guessing you want

    =IF(G3299="AX","Per Diem",IF(AND(F3299=64,G3299="AP"),"PT Sales",IF(AND(F3299=64,G3299="AF"),"Sales",VLOOKUP(F3299,Jobs,2,FALSE))))

  3. #3
    Registered User
    Join Date
    05-09-2007
    Posts
    4
    aha! that's what I thought I was doing the IF(AND...) incorrectly (missing the close parenthesis).

    Thanks Daddy Yo!

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

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