Forum Discussion

Nayls's avatar
Nayls
Copper Contributor
Feb 03, 2019

multiple If conditions with result from data source

what excel function do i use for multiple if conditions to read result from data table

 

Sheet 1 conditions are Column L and Column M.  These need to meet a data source specified on the data sheet.  This then needs to pull the column n result automatically from the data table on the data sheet. 

any suggestions?

excel
Formulas and Functions

6 Replies

  • Rich99's avatar
    Rich99
    Iron Contributor
    Feb 03, 2019

    Hi Nayls,

     

    Use a IF and AND function such as   =IF(AND(L3=1,M3=1),N3,0)

     

    Rich

    • Nayls's avatar
      Nayls
      Copper Contributor
      Feb 03, 2019

      thanks Rich.

      i was trying that but i think i am trying for to many conditions. 

       i need 2 columns to select conditions to then result in an answer from the data table.

      eg: sheet 1 cost is where i need the answer.  

      condition 1 is sheet 1 column L is manually inputed and needs to match data sheet table code

      condition 2 is sheet 1 column M is manually inputed and needs to match data sheet table code (titles which is the term at the top )

      the result will need to pull from the correct column and row to match the data in the table on the data sheet.  

      i think im trying to hard :)

       

       

Resources