16 янв. 2023 г. · In the "Profit Loss" sheet I'm using a nested XLOOKUP formula. For columns F, G, and H the formula uses "1" for the search mode and for columns K, L, and M it ...

17 дек. 2022 г. · To answer the question, to do the same with xlookup(), you can combine columns into a compound key, as attempted by the formula in the question.

13 июн. 2024 г. · I have a multi-column spill with data where some of the information is reflected incorrectly. We created a table to search if it's one of the incorrect records.

14 июл. 2022 г. · I have the two tables above. The first one is a product list and the 2nd one order list. I need to calculate order total. What is the good formula for doing ...

30 июн. 2024 г. · I'm creating a fantasy football spreadsheet and I'm looking to use double xlookup to return data based on two criteria.

8 июн. 2023 г. · I can never get XLOOKUP to work with multiple criteria. All I ever get is "Array arguments to XLOOKUP are of different size" no mater what data set I use.

9 авг. 2023 г. · I've been making a project that will lookup for a specific date then return all cells value with that specific date.

18 июн. 2024 г. · I have a data with A, B, and date.(For exampe name, salary) I want to search B based on A, but here's the problem. There are multiple Bs matched to A.

12 февр. 2023 г. · I have dates (mmm-yy) in one row (horizontal) and other dates in one column (vertical) I'm trying to match them and if the dates match, then ArrayFormula- ...

24 июл. 2023 г. · To achieve your desired result of pulling out all the details based on one cell with the product name, you can use the FILTER function along with IMPORTRANGE.