Hello,
I hope I posted this in the right section of the forum.
I want to make my own Journal. Currently I'm facing the problem that I need to retrieve multiple numbers from one table that have the same lookup_value.
My current formula:
=IF(XLOOKUP($A$1; Journal[Symbol]; Journal[Profit]); XLOOKUP($A$1;Journal[Symbol];Journal[Profit]); "None")
As an explanation: I'm looking for for the numbers of the lookup_value. The thing is that there might be none or multiple ones.
I got rid of the none and one entry in the table (although this seems a bit unnecessary) but is there a way for it to return all/multiple numbers?
Maybe there's an easier formula for my problem that I don't know of or haven't used yet.
Bookmarks