Complex find, lookup & import range of data/cells
I'm asking about the best way to filter, import, lookup, the data from a sheet looking like that. that's a finale datasheet to import multiple room types with all its prices, from different hotels, from different sheet. see the image below,
First column has a Hotel code(no duplication)
then it can have 1~12 rooms (name of room under the Room 1/2/3) can be duplicate
then you will see in the sheet the breakdown of prices for adult children and so on for each room.
Now I'm stuck for a couple of days for a method to filter and import only the criteria I'm looking for.
first it must bring the hotel range (because of multiple hotels on 1 sheet)
then select the room and import the prices belong to it,
then find the prices for the specific date entered. the last part is the easy 1 with just a vlooup. I'm stuck in the structure of begging.
Here's a copy of sheet, Editable and photo of the copied range
https://docs.google.com/spreadsheets/d/1UMKSJ43wByqnCzzZZY9qbzoL9rD0rH8A4_sF0djWpLI/edit?usp=sharing
The required search filters are in Sheet ('Tools')
you can solve this by using side columns to calculate items for dropdown for example like this:
- Calculating derived values
- Is there any way to do a bitwise shift right on a very large number in Google Sheets?
- Reset Column and Row sizes to default
- How to match data based on id in multiple google sheets having huge data(approx 27000 rows)?
- How to filter filter data after extracted data in Json form
- Is there a way to copy from a Google Sheets that is copy locked?
- Query for normalized Google Sheet table
- Sum the continuity in columns of Google sheet
- Count rows with not empty value
- how to import data from one google sheet to another google sheet without appscript
- How to wait for an HTTPrequest response
- Creating Nested List with Google Sheet Formulas from Pre-Made Tables (on 3 levels)
- Try construct dynamic cell reference from a google sheet in google app script for CopyTo method
- Google Apps Script BatchUpdate appending single apostrophe to output
- How to calculate value based on tax bracket using Google sheet formula?
- Google script to dynamically addressing a cell in google sheet
- Add 95 to a cell if the name and date in that row match another row with the same name and date
- Auto numbering rows in GoogleSheet
- Error message while automating data entry from web app contact form to google sheet
- How do I send email to user by appending my domain name to the user name in Google Apps Script?
- How to split comma-separated values across multiple rows dynamically?
- Replace multiple strings in Google Spreadsheet with script
- How to count the amount of times a substring appears in a range of cells?
- Query with multiple data types
- Count If Range Matches Lookup in another tab
- Google Sheets Query where data in either of two columns matches the value in a cell populated by a multi-select dropdown
- Trying to combine words and math in a single cell in google sheets
- Counting the previous sample over multiple conditions throughout the range
- How to randomly select by type probability all items from a google sheet column range
- Sort result of function by RHS column