Forum Discussion

John_Ekrem's avatar
John_Ekrem
Copper Contributor
Nov 30, 2021
Solved

XOPPSLAG (XLOOKUP) to show more than only the first hit?

Hi. I think that XOPPSLAG is a fantastic tool. I wonder if it's possible to make it not only show the first hit but to continue to show all the results? I have attached an example so you see what I m...
Formulas and Functions
  • OliverScheurich's avatar
    OliverScheurich
    Nov 30, 2021

    John_Ekrem 

    This can be done with the FILTER function as shown in attached file.

OliverScheurich's avatar
OliverScheurich
Gold Contributor
Nov 30, 2021

John_Ekrem 

This can be done with the FILTER function as shown in attached file.

John_Ekrem's avatar
John_Ekrem
Copper Contributor
Nov 30, 2021
Wow! FILTRER (in Norwegian) was POWERFUL too! This will solve a lot for me.
Thanky you very much and have a nice day!