Forum Discussion

Wille E's avatar
Wille E
Copper Contributor
Nov 06, 2018

Problem with a formula

Greetings,

I'm wondering how I'm going to write this formula to solve a problem that occurs every month that takes a lot of time.

If L2 contains "stage 1" and M2 "pre-sat" it will show the value from sheet "input c6" ,if L2 contains "stage 2" and M2 "pre sat" it will show input from "sheet d6", if L2 contains "stage 3" and M2 "pre-sat" it will show input from "Sheet e6", if L2 contains "stage 1" and M2 "post-sat" it will show input from "sheet c6" , if L2 contains "stage 2" and M2 "post-sat" it will show input from "sheet d6", if L2 contains "stage 3" and M2 "post sat" it will show input from "sheet e6".

So, I have a sheet that is named "Input" where I want to put numbers into and when I do so the formula shall recognize this change and automatically check the criterias above and retrieve the correct value.

Thank you for your help and feel free to raise any questions if something is unclear.

Please se the attached image.


Best regards

Stage 1Pre-satThis cell will retrieve its information from another sheet by using the formula
Stage 2Post-SatThis cell will retrieve its information from another sheet by using the formula
Stage 3Pre-satThis cell will retrieve its information from another sheet by using the formula

Resources