Forum Discussion
multiple If conditions with result from data source
Hi Nayls,
Use a IF and AND function such as =IF(AND(L3=1,M3=1),N3,0)
Rich
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 :)
- Rich99Feb 03, 2019Iron Contributorcan you send a sample xls?
- NaylsFeb 03, 2019Copper Contributor
attached
thanks
- Rich99Feb 03, 2019Iron Contributor
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