Forum Discussion
Aditya Jadhav
Jan 25, 2022Brass Contributor
Comparing and getting a result in a column based on another table
Dear All, Have been trying to get the output in the file by using Vlookup but it is not working hence need help to complete the task. Have a data set where there are 2 columns which are the top and...
- Jan 25, 2022
SergeiBaklan
Jan 25, 2022Diamond Contributor
As variant that could be
=IF(
[@[Geo_Top]] = "", "",
TEXTJOIN(", ", 1,
XLOOKUP( --[@[Geo_Top]],
Aqui[Geo_Top],
Aqui[Aquifers],
INDEX(Aqui[Aquifers], 1 ),
1 ):
XLOOKUP( --[@[Geo_Bottom]],
Aqui[Geo_Bottom],
Aqui[Aquifers],
INDEX(Aqui[Aquifers], ROWS(Aqui) ),
-1)
) )