+ Reply to Thread
Results 1 to 4 of 4

Need help with a VLOOKUP Type of Situation

  1. #1
    Registered User
    Join Date
    06-06-2016
    Location
    Florida
    MS-Off Ver
    Excel 2013
    Posts
    8

    Need help with a VLOOKUP Type of Situation

    Hello all,

    I've been banging my head against a wall on this for a while and figured it was time to ask for help. I have, what I thought to be, an easy VLOOKUP type of situation, but I can't get it to work. I have one sheet called "Hotels" with a list of hotels in column A. I have a different sheet called "Hotels with Search Volume" with mostly the same list of hotels (about 150 hotels removed) in column A, but then also numerical values in column B that correspond to each hotel. I need to move the numerical values from the "Hotels with Search Volume" sheet in column B to the other "Hotels" sheet and have the numerical values match up with the same hotels. How can I do this?

    Attached is the excel file.

    Thank you for your help!
    Attached Files Attached Files

  2. #2
    Forum Expert
    Join Date
    07-20-2011
    Location
    Mysore, India.
    MS-Off Ver
    Excel 2019
    Posts
    8,577

    Re: Need help with a VLOOKUP Type of Situation

    In B2 of Sheet "Hotels", then drag down.
    =IFERROR(VLOOKUP($A2,'Hotels with Search Volume'!$A$1:$B$3608,2,0),"")

  3. #3
    Registered User
    Join Date
    06-06-2016
    Location
    Florida
    MS-Off Ver
    Excel 2013
    Posts
    8

    Re: Need help with a VLOOKUP Type of Situation

    It works. I love you. I've actually been trying to figure this out for years and never got around to asking for help. I've probably spent 20 hours + trying to figure this out actually. Thank you so much!

  4. #4
    Forum Expert
    Join Date
    07-20-2011
    Location
    Mysore, India.
    MS-Off Ver
    Excel 2019
    Posts
    8,577

    Re: Need help with a VLOOKUP Type of Situation

    Welcome. Thanks for the feed back. Pl mark the thread solved.

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. [SOLVED] Need formula involving multiple Vlookup and/or multiple if situation
    By WKMAHESH in forum Excel Formulas & Functions
    Replies: 10
    Last Post: 08-19-2015, 04:22 PM
  2. VLookup type situation but returning the MAX?
    By Motox in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 08-16-2015, 09:46 PM
  3. [SOLVED] sudoku type situation
    By marciupial in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 07-02-2015, 12:18 PM
  4. Replies: 1
    Last Post: 07-20-2012, 05:50 PM
  5. Help with a Vlookup/max type situation
    By cwn7499 in forum Excel General
    Replies: 5
    Last Post: 02-15-2009, 11:19 PM
  6. [SOLVED] Probably a vlookup type ? not sure
    By Brian in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 07-18-2006, 10:50 AM
  7. [SOLVED] need help with a If=then situation.
    By FireBrick in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 05-02-2005, 11:06 AM

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