+ Reply to Thread
Results 1 to 6 of 6

Need help with tricky VLOOKUP

  1. #1
    Registered User
    Join Date
    05-31-2012
    Location
    USA
    MS-Off Ver
    Excel 2010
    Posts
    3

    Need help with tricky VLOOKUP

    I have 2 tables like the ones shown and I need help to get a string that can help me to update the "Address" column in the left table based on the criteria in the right table: If X > MinX and X < MaxX and Y > MinY and Y < MaxY then return Address for each Location. There must be some way to do this, right??

    ExcelHelp.PNG

  2. #2
    Registered User
    Join Date
    05-31-2012
    Location
    USA
    MS-Off Ver
    Excel 2010
    Posts
    3

    Re: Need help with tricky VLOOKUP (or something like that!)

    Sorry, here is the file with the tables.
    Attached Files Attached Files

  3. #3
    Registered User
    Join Date
    05-29-2012
    Location
    Ulaanbaatar, Mongolia
    MS-Off Ver
    Excel 2010
    Posts
    3

    Re: Need help with tricky VLOOKUP (or something like that!)

    Try this, I'm assuming you want to leave the cell empty if the criteria is not met.

    =IF(AND(B2>F2,B2<G2,C2>H2,C2<I2),J2,"")

  4. #4
    Registered User
    Join Date
    05-29-2012
    Location
    Ulaanbaatar, Mongolia
    MS-Off Ver
    Excel 2010
    Posts
    3

    Re: Need help with tricky VLOOKUP (or something like that!)

    Sorry, read your question wrongly, ignore above

  5. #5
    Forum Guru
    Join Date
    05-24-2011
    Location
    India
    MS-Off Ver
    Office 2021
    Posts
    2,237

    Re: Need help with tricky VLOOKUP (or something like that!)

    Try this in D2, with CTRL+SHIFT+ENTER, rather than just ENTER.

    Please Login or Register  to view this content.
    Then copy down.
    Regards,
    Haseeb Avarakkan

    __________________________________
    "Feedback is the breakfast of champions"

  6. #6
    Registered User
    Join Date
    05-31-2012
    Location
    USA
    MS-Off Ver
    Excel 2010
    Posts
    3

    Re: Need help with tricky VLOOKUP (or something like that!)

    Outstanding, this works well on the dummy sheet; but, more importantly, it works on the mega-dataset for work that prompted the question in the first place! Thanks very much Haseeb!

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Tags for this Thread

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