Hi peeps. I have tried searching a bit for what I am looking for but its
hard to put a name or keyword, I ma sure you guys will come up with it
straight away.

If you look at the excel file, I need to fill in the options and have a
total generated. I have no idea how to do this. I guess its a kind of
referencing to other cells.

I think this is way more simple than I have made it out to be.
Hopefully you peeps can help me out, I will attach the file, this will
give you a better idea I think.

CHeers!
Mike


+-------------------------------------------------------------------+
|Filename: Book2.zip |
|Download: http://www.excelforum.com/attachment.php?postid=5160 |
+-------------------------------------------------------------------+

--
mukcl
------------------------------------------------------------------------
mukcl's Profile: http://www.excelforum.com/member.php...o&userid=36599
View this thread: http://www.excelforum.com/showthread...hreadid=569432

mukcl wrote:
Hi peeps. I have tried searching a bit for what I am looking for but
its hard to put a name or keyword, I ma sure you guys will come up
with it straight away.

If you look at the excel file, I need to fill in the options and have
a total generated. I have no idea how to do this. I guess its a kind
of referencing to other cells.

I think this is way more simple than I have made it out to be.
Hopefully you peeps can help me out, I will attach the file, this will
give you a better idea I think.

CHeers!
Mike


Hi Mike,

I think you can use Data validation (menu Data, Data validation) and few
VLOOKUP formulas, as from you file modified at this link:

http://rapidshare.de/files/30600496/...ified.zip.html

--
Hope I helped you.

Thanks in advance for your feedback.

Ciao

Franz Verga from Italy