how to assign a code to a text

  • Thread starter Thread starter mangesh
  • Start date Start date
M

mangesh

hi
I want to assign a code to a text e.g code 1 means "cash A/c"
based on the code number I have to perform further processing. I a
trying to make a simple accounting package in excel
e.g
if cash a/c is credited it should redcue the cash balance
I want to give condition like this
if Column B is 1 that is cash a/c, reduce the balance of cash a/
 
Hi
you may set-up a lookup table with this assignemnts codes.
e.g.
A B
1 cashA/c
....

Now you can use VLOOKUP for this
e.g.
=VLOOKUP(1,A1:B20,2,0)
to get the assigned code
 
Don't know what values you might actually have in Column B
so this may be more code than you actually need.

=IF(ISERR(B9=1),oldformula,IF(B9=1, newformula, oldformula))

=IF(ISNUMBER(B9),IF(B9=1,newformula,oldformula),oldformula)
 
Back
Top