Ask Your Question

hlookup whole row?

asked 2018-10-13 18:16:31 +0100

clos911 gravatar image

updated 2020-08-16 12:25:22 +0100

Alex Kemp gravatar image

hello, I have a spreadsheets I have been trying to organize, Right now I have each row being single costumer's information, column 1 is customer name, column 2 is street address, column 3 is city and so on.. What I have been trying to accomplish is having a separate sheet for each city, since my spreadsheet is not alphabetical to the city name, I have been using the find and replace to get all results for my city search but it would be 100X easier if I could have each city in it's own sheet. using =hlookup I am only able to show the city name, I would like the entire row with all customer information to show up. not sure if i'm doing it right. any help would be appreciated!

edit retag flag offensive close merge delete

1 Answer

Sort by » oldest newest most voted

answered 2018-10-14 00:35:23 +0100

m.a.riosv gravatar image

I think having the data duplicate in several sheet give to a issues and make the spreadsheet slow if there is a lot of data.

Several ways to view the data of one or several cities:

  • With Menu/Data/Autofilter, clicking on the arrow for cities you can select several or one of them.

  • With Menu/Data/More filters/Standard filter - Options - Copy results to, you can send the selection to other sheet or range.

  • With Menu/Insert/Pivot table, results can be organized by cities, filtered, or even you can create one pivot table for every city filtering.

edit flag offensive delete link more


Thank you! Menu/Insert/Pivot table worked out great! Saves me from troubleshooting the syntax!!

clos911 gravatar imageclos911 ( 2018-10-14 02:22:47 +0100 )edit
Login/Signup to Answer

Question Tools

1 follower


Asked: 2018-10-13 18:16:31 +0100

Seen: 136 times

Last updated: Oct 14 '18