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 mean.
If it's not possible (think not), is it another function I can use to do this?
Thanks!
This can be done with the FILTER function as shown in attached file.
3 Replies
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.
This can be done with the FILTER function as shown in attached file.
- Wow! FILTRER (in Norwegian) was POWERFUL too! This will solve a lot for me.
Thanky you very much and have a nice day!
