Multiple table VLOOKUP, MATCH, INDEX functions

[kevhong]

Hi everyone,

Thanks for helping me. I should remember how to do this but it's been so long since I've used Excel. So I'm trying to buy a house and in order to better present it and analyze the best options, this is what I need to do.

Attached is the file...
Sheet 1 named "Problem"
I want to be able to type in a neighborhood in the gray area and then it will search for the neighborhood on the next sheet named "Tables" and plug in all the values that are empty on sheet one. I don't want to specify the neighborhood because I want to be able to search one hundred neighborhoods so I need a way to search for the neighborhood. Let me know asap. Thank you so much for your help guys!

http://www.ozgrid.com/forum/attachment.php?attachmentid=40137&d=1312425454

 

[kevhong]

nobody? Please?

 

[Peter_SSs]

Welcome to the MrExcel board!

Many of the (especially experienced) helpers here choose not to download files from other sites. Also, due to security issues at work sites, many users are unable to download such files.

You will get many more potential helpers if you explain your problem clearly in words and, if needed, post a small screen shot or two directly in your post. My signature block below suggests 3 ways you can do that. Test them out in the Test Here forum.