I know this is really simple but I just cannot get it right!! Basically I have a common reference in 2 worksheets. This reference is in column G in one sheet (sheet 1), and column A in the second sheet (sheet 2).
I want to look up the number in sheet 2, and if column T is 'Yes', return the value in column B. However, if column T is "No" I need it to retrun the result in column X.
As I said, I know this is a dead simple nested V lookup but could do with some help - cheers!!
I want to look up the number in sheet 2, and if column T is 'Yes', return the value in column B. However, if column T is "No" I need it to retrun the result in column X.
As I said, I know this is a dead simple nested V lookup but could do with some help - cheers!!