Forum Discussion
Microsoft for Home 2019 Excel version 2023 build 16627.20212
The following formula works but is limited to querying 64 values in a single cell. I have Row 1 Col A Col B Col C Col D Row 2 Date...
Maybe you can use an array formula to query by array in Excel.
Here’s an example of how you can use it:
=IFERROR(INDEX($C$2:$D$5,SMALL(IF($A$3=$B$2:$B$5,ROW($B$2:$B$5)-ROW($B$2)+1),ROWS($D$2:D2)),COLUMN(A1)),"")
This formula will return the values from columns C and D if the value in column A matches the value in column B.
You can adjust the ranges to match your data.
Array formula: Ctrl+Shift+Enter.
I hope that helps!
I know I don't know anything (Socrates)