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....
excel
Formulas and Functions
Rich99's avatar
Rich99
Iron Contributor
Feb 03, 2019

Nayls,

I have used data validation for the code and term data input (this ensures the values are always in the data lookup). for the cost value I have used Vlookup with row and column selected by match for the code and term values.

 

Revised spreadsheet attached with changed cells highlighted

 

Rich

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

    thank you so much!!!

    i got so hung up on the multiple IF / AND idea that i didnt even go for a VLOOKUP.

     

    champion :)

    thanks

Resources