Hey, I have a question about using Excel. I use Excel and...

FAQS.ORG makes no guarantees as to the accuracy of the posts. Each post is the personal opinion of the poster. These posts are not intended to substitute for medical, tax, legal, investment, accounting, or other professional advice. FAQS.ORG does not endorse any opinion or any product or service mentioned mentioned in these posts.

<< Back to: comp.apps.spreadsheets FAQ

[ Home | FAQ-Related Q&As | General Q&As | Answered Questions ]

Question by dajiao
Submitted on 6/22/2004
Related FAQ: comp.apps.spreadsheets FAQ
Rating: Not yet rated	Rate this question:
Hey, I have a question about using Excel. I use Excel and get a column of percentage number. I want Excel automatically read the percentage and put a related figure on the next column. The relationship is as follows: 5%+ better than budget/target "one figure/picture" w/n 5% of budget/target "one figure/picture" 5-10% below budget/target "one figure/picture" 10%+ below budget/target "one figure/picture" I tried to use VLookup function. But I can only link a letter on the next column, not a figure or picture. Could any other way handle this? Thanks, dajiao

Your name or nickname:
If you'd like to create a new account or access your existing account, put in your password here:
Your answer: