Results 1 to 2 of 2
  1. #1
    Star Lounger
    Join Date
    Jun 2010
    Location
    Quincy, MA
    Posts
    62
    Thanks
    2
    Thanked 0 Times in 0 Posts

    VLOOKUP Question

    Hello, on the attached sample file, I have a situation where I have multiple clients all recieving something in Column B, and the deadline for receipt is the same for all except one. My experience with VLOOKUP is that once it finds the first instance of the criteria, it doesn't search any further; I suspect that that is because I haven't told it do so . Is there a way for me to do this so that cell D5 returns the correct value as it applies to the combination of Columns A and B? Thanks, Pete
    Attached Files Attached Files

  2. #2
    Lounger
    Join Date
    Apr 2012
    Location
    Abergavenny, Wales, UK
    Posts
    25
    Thanks
    0
    Thanked 3 Times in 3 Posts
    Hi

    Your problem is that you were looking at a column that has duplicates.
    By changing the named range daveg to a dynamic range starting in column B of Database
    daveg
    to
    =Database!$B$3:INDEX(Database!$D:$D,COUNTA(Databas e!$B:$B))
    and the formula in D2 to
    =IF(A2=""," ",VLOOKUP(A2,daveg,3,FALSE))

    then it will work.

    The attached workbook also shows a method using Index and Match as well, using 2 new defined ranges
    Attached Files Attached Files
    Regards
    Roger Govier
    Microsoft Excel MVP

Posting Permissions

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