+ Reply to Thread
Results 1 to 6 of 6

IF And Vlookup problem

  1. #1
    Registered User
    Join Date
    02-23-2005
    Posts
    16

    Red face IF And Vlookup problem

    Hi,

    I am trying to look at 2 fields in one sheet and have a vlookup bring over 2 other fields in another sheet based on the first criteria but its not returning the correct amount based of the first criteria. Heres an example,

    IF(AND(B6="Host",D6="WTK-HR"),IF(D6="WTK-HR",VLOOKUP(D6,EECnt,3,FALSE),IF(B6="Host",VLOOKUP(AQ6,WatchList,5,FALSE),"NA")))

    So I want to vlookup in the Watchlist Tab, that if its WTK-HR AND what is in AQ6 cell ie (500-1000 employees), then bring me back the price for the correct employee count. The answer that its returning is the first WTK-HR it sees in the Watchlist which is for the wrong employee count. I know I need a correlation between WTK-HR and the employee count but I dont know how to make that happen.

    Thanks in advance!
    A

  2. #2
    Forum Expert
    Join Date
    12-23-2006
    Location
    germany
    MS-Off Ver
    XL2003 / 2007 / 2010
    Posts
    6,326

    Re: IF And Vlookup problem

    To best describe or illustrate your problem you would be better off attaching a dummy workbook, the workbook should contain the same structure and some dummy data of the same type as the type you have in your real workbook - so, if a cell contains numbers & letters in this format abc-123 then that should be reflected in the dummy workbook.

    If needed supply a before and after sheet in the workbook so the person helping you can see what you are trying to achieve.

    Doing this will ensure you get the result you need!

  3. #3
    Registered User
    Join Date
    11-03-2010
    Location
    aurad (B),Bidar Division
    MS-Off Ver
    Excel 2010
    Posts
    14

    Re: IF And Vlookup problem

    u r formula syntax may be wrong

  4. #4
    Registered User
    Join Date
    02-23-2005
    Posts
    16

    Re: IF And Vlookup problem

    Is it possible to vlookup 2 cells but return another?
    Such vlookup a part # in one cell in one tab and another cell in the same tab and return the list price from the vlookup table? Like this?
    IF(AND(VLOOKUP(G4,WatchList,5,0)),0,VLOOKUP(Q4,WatchList!$D$6:$E$49,2,0))

    I want that whatever is in G4 and Q4 to be vlookup'd in the Watchlist tab and return the list price. However, this formula is giving me zeros.

    Any suggestions?

    AESP

  5. #5
    Forum Expert
    Join Date
    12-23-2006
    Location
    germany
    MS-Off Ver
    XL2003 / 2007 / 2010
    Posts
    6,326

    Re: IF And Vlookup problem

    I suggest you read my last post

  6. #6
    Registered User
    Join Date
    11-20-2010
    Location
    new brunswick, Canada
    MS-Off Ver
    Excel 2003
    Posts
    10

    Re: IF And Vlookup problem

    Agreed with arthurbr, without examples it would be very difficult to give you a proper answer. Just as a suggestion you may not be referencing proper columns.

+ 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