Hi all,
All help is appreciated.
Currrently Column R contains a Y or N.
Column S is a drop down selection from another tab
Column T is the target of this question.
What I want to achieve is the following:
If R contains a Y, check S, S will contain a value from tab 3 range B2 through B13, then enter the value from tab 3 column G on the same row and the drop down selection is S.
I hope I have explained this correctly!
Ben
All help is appreciated.
Currrently Column R contains a Y or N.
Column S is a drop down selection from another tab
Column T is the target of this question.
What I want to achieve is the following:
If R contains a Y, check S, S will contain a value from tab 3 range B2 through B13, then enter the value from tab 3 column G on the same row and the drop down selection is S.
I hope I have explained this correctly!
Ben