Need help with a VLOOKUP Type of Situation...Again

Hello all,

kvsrinivasamurthy gracefully helped me out with a vlookup situation in the past on this thread:

http://www.excelforum.com/showthread...t=#post4404701

I'm trying to use the formula he/she gave me for something else and it's sort of working but not all the way and I can't figure out why. It's the same situation as before. I have a list of resorts in sheet labeled "hotels". I have a similar list of resorts (some of the names are a little different) on sheet labeled "hotels with search volume" but on this second sheet I have addresses in column B. I need to move the addresses from column B in sheet "hotels with search volume" over to column B on the "hotels" sheet. This formula:

=IFERROR(VLOOKUP($A2,'Hotels with search volume'!$A$1:$B$3608,2,0),"")

Brings in some of them, but I can't figure out why not all of them are being moved over and why some are "0". For example, "Harbor Vacations Club" has an address associated with it on the "hotels with search volume" sheet, but that address isn't getting pulled over to the "Hotels" sheet. Also, "Harborside Inn" also has an address associated with it on the "hotels with search volume" sheet, but that address is just being shown as a "0" on the "Hotels" sheet.

Any ideas? Would really appreciate it!

Thank you!

Dave

for starters the "0" is return when there is a match but the referenced cell is empty. one way to overcome that is

Please Login or Register  to view this content.

Got it. Thanks so much!

One more question, do you know why I can't use a filter and enter "/For" to find all of the cells with "/For" in them on the "hotels with search volume" sheet? Same thing with "/Attractions" "/Reviews"? If I do a ctrl + f and search "/for" it will find them...

Nevermind. I got it. I had a few blank cells and that was causing the issue. Never had that problem before.