Forum Discussion
Solved
Formula x.zoeken in two different tabs
I'm searching for a formula to search a cel (C2) in two different tabpages (inventaris and contracten digisprong 1-2-3) But the formula isn't right! =X.ZOEKEN(C2;INDIRECT(KIEZEN("inventaris";...
Thanks! That would look like this:
=X.ZOEKEN(C2;inventaris!C:C;inventaris!H:H;X.ZOEKEN(C2;'Contracten digisprong 1-2-3'!C:C;'Contracten digisprong 1-2-3'!H:H;"Niet Gevonden!"))
How exactly do you want to search? Do you want to search one sheet first and if not found, search the second sheet? Or do you want to return results from both sheets?
Thanks! That would look like this:
=X.ZOEKEN(C2;inventaris!C:C;inventaris!H:H;X.ZOEKEN(C2;'Contracten digisprong 1-2-3'!C:C;'Contracten digisprong 1-2-3'!H:H;"Niet Gevonden!"))
- Great, it works. Thank you!