Hi, I am having a lot of trouble trying to figure this out. I am not that advance in excel but I tried to do my own research and failed.
I am trying to use HLOOKUP to find a location in another sheet and display all the names in that specific location. Also can change location at will and will display the names for that location.
I have attached a spreadsheet that kinda has what I want. It does not have to be HLOOKUP but that is all I know, Hlookup and vlookup. I am stumped please help.
Thanks in advance.
Bookmarks