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.

     

Harun24HR's avatar
Harun24HR
Bronze Contributor
Dec 10, 2024

I would recommend using FILTER() function.

=FILTER(C2:C6,(A2:A6=B10)*(B2:B6=C10),"Not Found")

 

Resources