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!
Bookmarks