Forum Discussion
SEN8660
Jan 04, 2022Copper Contributor
xlookup in a table, how to find a cell when knowing how to find the column and how to find the row
In a table I have information of inventory of all items on all dates in a month. By using XLOOKUP I can easy find the item and also by using XLOOKUP I can easy find the date, But how do I use both in...
Riny_van_Eekelen
Jan 05, 2022Platinum Contributor
SEN8660 Since your Excel version supports XLOOKUP, you can also use the FILTER function. Use that one in stead. The formula structure will than then be like this:
=FILTER( data_range, (item_column=item) * (date_column=date) )
where "data_range" points to the one or more columns from which you want to extract the data for an item on a particular date.