Hi
It's not clear from your post how the figures are added/multiplied to get
whichever result you require. I think the only option is probably a macro.

AndyB.

"lowspark" wrote in
message ...

Can i use the lookup function for this?? as i read about it it sees to
only look at one cell at a time? I would like to have it look at the
last cell with in a column that has data input? thanks again for your
help
z


--
lowspark
------------------------------------------------------------------------
lowspark's Profile:
http://www.excelforum.com/member.php...o&userid=34853
View this thread: http://www.excelforum.com/showthread...hreadid=545988