Forum Discussion
Return value from 2 criteria lookup array, based on list of horizontal and vertical lookup value.
Hello, I want to return the price based on lookup values (dates in horizontal) and (symbol in vertical) just like the format in the right from the data source which is on the left. Both are different...
RohitJung As a variant, use FILTER with structured table references.
=FILTER(Table1[[Price]:[Price]],(Table1[[Date]:[Date]]=F$1)*(Table1[[Symbol]:[Symbol]]=$E2))
Riny_van_Eekelen
Thank you very much for responding. I tried but couldn't make it.The Dummy file is here where I tried this function.
https://filebin.net/f3y4a5gjwb3a084a
In real Data Source is auto-updated from the folder where daily excel records are stored, and the task is done in a different sheet.
