Forum Discussion
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...
This can be done with the FILTER function as shown in attached file.
Hi John_Ekrem
Since you like XLOOKUP, you'll probably love FILTER 🙂
=FILTER(B1:C8;A1:A8=A13)To manage "not found", append IFERROR;
=IFERROR(FILTER(B1:C8;A1:A8=A13);"Finnes ikke")(I changed the hard coded five to get the looked up value from cell A13.