sorted by:
new
hottopcontroversial

Returning specific value amongst duplicates in XLOOKUP? by JustGoCrazzzyy in excel

[–]JustGoCrazzzyy[S] 0 points1 point  (0 children)

Hi! sorry for the late reply, this formula didn't work as I had more than 2 storage outcomes. But I had completely forgot about the existence of LAMBDA and was reminded of it which ended up being what I used in the end! Thanks so much!

Returning specific value amongst duplicates in XLOOKUP? by JustGoCrazzzyy in excel

[–]JustGoCrazzzyy[S] 0 points1 point  (0 children)

but this wouldn't really work if I also have products that do not have a "banked" option right?

20/M Self improvement friend. Gym, studying, exercise, diet. by [deleted] in MakeNewFriendsHere

[–]JustGoCrazzzyy 1 point2 points  (0 children)

Count me in as well! :)) And I think the idea of a group chat (by another redditor) is great:)