Forum Discussion

CeuE3980's avatar
CeuE3980
Copper Contributor
Dec 15, 2021
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";...
excel
Formulas and Functions
  • HansVogelaar's avatar
    HansVogelaar
    Dec 16, 2021

    CeuE3980 

    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!"))

CeuE3980's avatar
CeuE3980
Copper Contributor
Dec 16, 2021

HansVogelaar 

 

I want to search one sheet first and if not found, search the second sheet.

HansVogelaar's avatar
HansVogelaar
MVP
Dec 16, 2021

CeuE3980 

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!"))

  • CeuE3980's avatar
    CeuE3980
    Copper Contributor
    Dec 16, 2021
    Great, it works. Thank you!

Resources