ssblue
asked on
Excel IF statement
column C (ActType) has the following items in it: PRDIEM PSNEOT PSNE1 PSCROT PSPR1 PSPR2
I need to fill column K (GL) with the appropriate GL acct #'s: 800100 800110 800200
Based on the following:
PRDIEM is 800200
PSNEOT is 800110
PSNE1 is 800100
PSCROT is 800110
PSPR1 is 800100
PSPR2 is 800100
I need to fill column K (GL) with the appropriate GL acct #'s: 800100 800110 800200
Based on the following:
PRDIEM is 800200
PSNEOT is 800110
PSNE1 is 800100
PSCROT is 800110
PSPR1 is 800100
PSPR2 is 800100
ASKER
the top equation is returning TRUE
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Thanks!
Open in new window
Else create a Table in Sheet2 and do the vlookup with below formula:Open in new window
ssblue_GL-Account.xlsx