sortinggoogle-sheetsgoogle-sheets-formulamatchvlookup
Multiple Search Key in a Matrix
I'm trying to solve this problem since some days now but it seems I have reached a dead end. Maybe someone would be able to help me.
I have two sheets. The first one contains the list of my clients and their delivery number depending of the weekday.
In my second sheet I would like to get the delivery number of the client (red cells) depending of the weekday I select (yellow cells).
I tried VLOOKUP formula, INDEX/MATCH, QUERY but I wasn't able to find a way to get the delivery number depending of the client's name and the weekday. I think the main issue is that in the first sheet the weekday is a column title.
Maybe the solution is simply to build my tables differently...
Thank you for your help
Solution
all you need is simple vlookup:
=INDEX(IFNA(VLOOKUP(A9:A11&B9:B11,
SPLIT(FLATTEN(A2:A4&B1:D1&""&B2:D4), ""), 2, )))
- Sorting by reference price in Shopware
- Is it possible to reduce number of comparisons from O(N^2) to O(N) in brute-force sorting by using multiplication?
- JavaFx sorting visualiser
- Formula to find missing serial numbers
- What is the complexity of the sorted() function?
- TypeError: 'cmp' is an invalid keyword argument for this function
- Sort Proxy Array of Objects, localeCompare is not a function
- Is it possible to sort numbers in a QTreeWidget column?
- Find longest string in an array
- How to sort List<Integer[]> in java?
- I want to remove 3 dots(option) from Header in MudDataGrid using MudBlazor
- How to sort an array of objects correctly by an object's alphanumeric name value?
- Paging and sorting over Collection
- Asp Core, How to use PagingList<T>.CreateAsync() with a viewModel?
- Sorting and Paging on repository
- Angular2 - Table using *ngFor with paging and sorting
- How to avoid loading data from server every time doing sorting/paging with ngtable
- How to do paging in Angular manually
- How to best perform paging and sorting from multiple sources in JavaScript mashup
- Folders first in paged results using CamlQuery and ListItemCollectionPosition
- Order array of objects based on dependencies list?
- Datatable show/hide sorting/paging
- How to persist sorting and paging in ASP.NET MVC WebGrid when updating via ajax?
- Sorting a Vector Containing Pointer to Struct VS Struct
- Segmentation error when implementing the Hoare quick sort method
- How to sort a dictionary based on a list in python
- Return a new string that sorts between two given strings
- How to use std::sort to sort an array in C++
- Swift Quicksort Algorithm
- Insertion Sort from Right to left with Javascript