Forum Discussion

Oskar_P_J's avatar
Oskar_P_J
Copper Contributor
Mar 29, 2022
Solved

Excel Wenn(Und -> Status aktualisieren

Hallo liebe Community,   Ich wollte mir die Arbeit mit Excel etwas erleichtern, aufgrund meiner fehlenden Kenntnisse bin ich jedoch nicht in der Lage es selber zu machen.   Kurz zu dem Ablauf. Es...
excel
Formulas and Functions
  • OliverScheurich's avatar
    OliverScheurich
    Mar 31, 2022

    Oskar_P_J 

    =IF(NOT(ISNA(VLOOKUP(Tabelle1!C2&Tabelle1!D2&"fertig",Tabelle2!A:A&Tabelle2!B:B&Tabelle2!D:D,1,FALSE))),"x","--")
    =IF(NOT(ISNA(MATCH(Tabelle1!C2&Tabelle1!D2&"fertig",Tabelle2!A:A&Tabelle2!B:B&Tabelle2!D:D,0))),"x","--")

    It seems to work with VLOOKUP or MATCH. Enter the formulas with ctrl+shift+enter if you don't work with Office365 or 2021.

OliverScheurich's avatar
OliverScheurich
Gold Contributor
Mar 31, 2022

Oskar_P_J 

=IF(NOT(ISNA(VLOOKUP(Tabelle1!C2&Tabelle1!D2&"fertig",Tabelle2!A:A&Tabelle2!B:B&Tabelle2!D:D,1,FALSE))),"x","--")
=IF(NOT(ISNA(MATCH(Tabelle1!C2&Tabelle1!D2&"fertig",Tabelle2!A:A&Tabelle2!B:B&Tabelle2!D:D,0))),"x","--")

It seems to work with VLOOKUP or MATCH. Enter the formulas with ctrl+shift+enter if you don't work with Office365 or 2021.

Oskar_P_J's avatar
Oskar_P_J
Copper Contributor
Apr 01, 2022
OliverScheurich Thank you! I Think that should work.