Hi Mr Excel User community!
Need a little help her with an IF statement with Vlookup Looking for the result in column C. Logic blow the table
Thanks!
<COLGROUP><COL style="WIDTH: 21pt; mso-width-source: userset; mso-width-alt: 1024" width=28><COL style="WIDTH: 80pt; mso-width-source: userset; mso-width-alt: 3913" width=107><COL style="WIDTH: 66pt; mso-width-source: userset; mso-width-alt: 3218" width=88><COL style="WIDTH: 99pt; mso-width-source: userset; mso-width-alt: 4827" width=132><COL style="WIDTH: 76pt; mso-width-source: userset; mso-width-alt: 3693" width=101><TBODY>
</TBODY>
Need a little help her with an IF statement with Vlookup Looking for the result in column C. Logic blow the table
Thanks!
A | B | C | ||
1 | Employee | Product | Result | |
2 | Blank | Software | No Name Software | |
3 | Blank | Services | No Name Services | |
4 | Joe Smith | Services | Joe Smith | |
If Employee name has no value (i.e. Blank) and Product | ||||
equals Software, then code as "No name Software" | ||||
and if Emplyee name has no value and product equals Services | ||||
then code as No Name Services Otherwise Vlookup employee name | ||||
and code the result from the vlookup table |
<COLGROUP><COL style="WIDTH: 21pt; mso-width-source: userset; mso-width-alt: 1024" width=28><COL style="WIDTH: 80pt; mso-width-source: userset; mso-width-alt: 3913" width=107><COL style="WIDTH: 66pt; mso-width-source: userset; mso-width-alt: 3218" width=88><COL style="WIDTH: 99pt; mso-width-source: userset; mso-width-alt: 4827" width=132><COL style="WIDTH: 76pt; mso-width-source: userset; mso-width-alt: 3693" width=101><TBODY>
</TBODY>