I have several questions so if it's ok with you I'll ask then one at a time (that'll give me time to digest any answers).
Ok, here's problem 1. I want the person using the spreadsheet to input a value into cell A1. The value that is input is going to be either A,B,C,D or E. The values of cells A2 and A3 will vary depending on what is input into A1. Basically (and in simple terms) what I want the formula to work out is this: If A1=A then A2=10 and A3=20 If A1=B then A2=30 and A3=40 If A1=C then A2=50 and A3=60 If A1=D then A2=70 and A3=80 If A1=E then A2=90 and A3=100 I hope this makes sense. Any help is greatly appreciated. Regards. Dean. -- ---------------------------------------------------------------------------------- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com <><><><><><><><><><><><><><><><><><><><><><> Like our page on facebook , Just follow below link http://www.facebook.com/pages/discussexcelcom/160307843985936?v=wall&ref=ts
