Hi all
I'm working on a spreadsheet and I'm trying to find values that match those in another table.
The formula I've tried to do this is:
{=IFERROR(
INDEX(ClientPortfolioDataTable[Holding],
SMALL(
IF(
ClientPortfolioDataTable[Holding]=Low[Holding],
ROW(ClientPortfolioDataTable[Holding])-ROW('Client Portfolio Data Table'!B$2)+1
),
ROWS('Client Portfolio Data Table'!B$2:'Client Portfolio Data Table'!B3)
)
),"")}
The [Holding] refers to the value I want to return, and Low[Holding] refers to the value I want to check it against. When I action this it just comes out as blank though.
To clarify the process I'm trying to action, I'm wanting the formula to search the ClientPortfolioDataTable[Holding] column (Column B:B) and return any values that match the Low[Holding] column in the other table, to repeat the process I've used the ROW/ROWS function, hoping to find all entries.
Does anyone know how I can fix this? Or is there a simpler way to do this e.g. with Power Query?
Thanks in advance
Bookmarks