vlookup and if function
 

hiya all
i'm trying to make 2 dropdown lists which when added with a figure in a 3rd
cell copies the cell into another column.

i.e
a1=(dropdown"january") b1=(dropdown"paid") c1=("manual input"100)

in g1 i want the total 100(c1) only if a1& b1 is set above.

but what i also want is if a1=jan,b1=paid,c1=200 and g1 is full(1) then
enter 200(c1) into g2

please help.
--
deejay

vlookup and if function
 

On the face of it, this might suffice
In G1: =IF(AND(A1="january",B1="Paid"),C1,"")
In G2: =IF(G1=200,G1,"")
--
Max
Singapore
http://savefile.com/projects/236895
Downloads:17,500 Files:358 Subscribers:55
xdemechanik
---
"confused deejay" wrote:
i'm trying to make 2 dropdown lists which when added with a figure in a 3rd
cell copies the cell into another column.

i.e
a1=(dropdown"january") b1=(dropdown"paid") c1=("manual input"100)

in g1 i want the total 100(c1) only if a1& b1 is set above.

but what i also want is if a1=jan,b1=paid,c1=200 and g1 is full(1) then
enter 200(c1) into g2

please help.
--
deejay

vlookup and if function
 

hiya max thanx for the reply tried your sum but didn't work.
might be my fault, then again what i'm asking might be impossible!
your sum worked on the first base but when i entered a new figure in c1 it
changed g1 aswell i need it so once the sum has been added it stays and the
next time its added its added one row down (g2)(g3)(g4) so on... without
changing the figure in (g1)(g2)(g3)
--
deejay


"Max" wrote:

On the face of it, this might suffice
In G1: =IF(AND(A1="january",B1="Paid"),C1,"")
In G2: =IF(G1=200,G1,"")
--
Max
Singapore
http://savefile.com/projects/236895
Downloads:17,500 Files:358 Subscribers:55
xdemechanik
---
"confused deejay" wrote:
i'm trying to make 2 dropdown lists which when added with a figure in a 3rd
cell copies the cell into another column.

i.e
a1=(dropdown"january") b1=(dropdown"paid") c1=("manual input"100)

in g1 i want the total 100(c1) only if a1& b1 is set above.

but what i also want is if a1=jan,b1=paid,c1=200 and g1 is full(1) then
enter 200(c1) into g2

please help.
--
deejay

vlookup and if function
 

Not sure whether the lack of responses from others here over the past few
days confirms your statement:
.. then again what i'm asking might be impossible!

You might want to try posting in .programming
--
Max
Singapore
http://savefile.com/projects/236895
Downloads:17,500, Files:358, Subscribers:55
xdemechanik
---
"confused deejay" wrote in
message ...
hiya max thanx for the reply tried your sum but didn't work.
might be my fault, then again what i'm asking might be impossible!
your sum worked on the first base but when i entered a new figure in c1 it
changed g1 aswell i need it so once the sum has been added it stays and
the
next time its added its added one row down (g2)(g3)(g4) so on... without
changing the figure in (g1)(g2)(g3)
--
deejay

vlookup and if function
 

probably lol i've got some IT blokes looking at it for me. i guess what i'm
trying to do should be possible if you take this site for instance i'm
writing this text on a window box! that window box then adds what i write to
the main page display. that display is never taken off its just added too!!
the next time i open this window this message will be deleted, although
remaining on the main page. all i wanna do is incorporate this tech into an
excel sheet.
--
deejay