HostStage
Elite Member
- May 20, 2010
- 2,083
- 1,836
Hello,
I've a specific task to get done on Excel. I'm loosing countless of time because of this manual thing while i know it can be automated.
Here is in words, what i would need :
If value from A1(sheet2) exists in C(sheet1), then display B(sheet1), if not display "message"
This formula needs to be applied only if D1(sheet2) is equal to several custom values, if not let it be.
Note 1 the value aren't numbers.
Note 2 the sheets are custom named
To name the obvious, the formula needs to be extended to the whole A(sheet2) column.
$5 if simple Excel formula, $10 if VB macro
I've a specific task to get done on Excel. I'm loosing countless of time because of this manual thing while i know it can be automated.
Here is in words, what i would need :
If value from A1(sheet2) exists in C(sheet1), then display B(sheet1), if not display "message"
This formula needs to be applied only if D1(sheet2) is equal to several custom values, if not let it be.
Note 1 the value aren't numbers.
Note 2 the sheets are custom named
To name the obvious, the formula needs to be extended to the whole A(sheet2) column.
$5 if simple Excel formula, $10 if VB macro