Forum Discussion

jhcj's avatar
jhcj
Copper Contributor
Dec 05, 2024
Solved

Filling values if conditions are met

I want to have excel use a lookup to fill up a column if below criterias are met (I will update these criterias in a separate sheet as a table):  So for example, my spreadsheet would look like b...
Formulas and Functions
  • Riny_van_Eekelen's avatar
    Riny_van_Eekelen
    Dec 09, 2024

    Assuming you are using a modern Excel version try this:

    =XLOOKUP(
    A10 & "_" & B10,
    Table3[Customer] & "_" & Table3[Origin],
    Table3[Equipment],
    "Not found"
)

    where Table3 refers to a table as shown in the picture below.

     

Riny_van_Eekelen's avatar
Riny_van_Eekelen
Platinum Contributor
Dec 09, 2024

Assuming you are using a modern Excel version try this:

=XLOOKUP(
    A10 & "_" & B10,
    Table3[Customer] & "_" & Table3[Origin],
    Table3[Equipment],
    "Not found"
)

where Table3 refers to a table as shown in the picture below.

 

Resources