Dears,
kindly I want to fill Column sub Category 1 & 2 from another sheet with the Following Condition
Sub Category 1 will be :
if (Activity coloumn = 211 or 212) : COGS
if (Activity [FONT="]coloumn[/FONT][FONT="]= 111 or 231) : G&A[/FONT]
if (Activity [FONT="]coloumn[/FONT][FONT="]= 111 or 231 & Cost center = 312 & 341 ) : S&M
i think i need to make multi If Function + Vlookup [/FONT][FONT="] [/FONT]
<tbody>
</tbody>
kindly I want to fill Column sub Category 1 & 2 from another sheet with the Following Condition
Sub Category 1 will be :
if (Activity coloumn = 211 or 212) : COGS
if (Activity [FONT="]coloumn[/FONT][FONT="]= 111 or 231) : G&A[/FONT]
if (Activity [FONT="]coloumn[/FONT][FONT="]= 111 or 231 & Cost center = 312 & 341 ) : S&M
i think i need to make multi If Function + Vlookup [/FONT][FONT="] [/FONT]
ِAccount Number | Activity | Cost Center | SUb Category 1 | Sub Category 2 | |
<tbody> </tbody> | 211 | 211 | |||
<tbody> </tbody> | 212 | 325 | |||
<tbody> </tbody> | 111 | 400 | |||
<tbody> </tbody> | 231 | 410 | |||
<tbody> </tbody> | 231 | 312 | |||
<tbody> </tbody> | 111 | 341 |
<tbody>
</tbody>