Forum Discussion
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";"Contracten digisprong 1-2-3"))&'!C:C;'!H:H)
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!"))
4 Replies
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!"))
