98.7% Of all customers recommend us, we're so confident about our results we publish all reviews and stats
View Live Stats View ReviewsForum home » Delegate support and help forum » Microsoft Excel Training and help » excel 2003 visual basic intermediate course - Excel vlookup if statements
excel 2003 visual basic intermediate course - Excel vlookup if statements
Resolved · Low Priority · Version Standard
Frances has attended:
Visio Introduction course
Excel vlookup if statements
Can you use Vlookup within an IF statement?
RE: excel vlookup if statements
Hi Frances
Thank you for your question. Sorry about the delay in replying.
The answer is yes, you can use IF statements in conjunction with Vlookups. For example, if you wanted to enter a value from a table into a cell, based on what was in another cell, you could start with an IF statement and then enter the Vlookup in the 'value if true' part of the IF statement.
I've attached an example that you can look at. The formula is in the yellow cell. If you enter anything less than 100 in cell A1, then the yellow cell should say 0. If you enter 100 in cell A1, it should say 1; if you enter 200 in cell A1, it should say 2; if you enter 300 in cell A1, it should say 3.
I hope this helps.
Amanda
Training information:
See also:
Welcome. Please choose your application (eg. Excel) and then post your question. Our Microsoft Qualified trainers will then respond within 24 hours (working days). Frequently Asked Questions
Any suggestions, questions or comments? Please post in the Improve the forum thread. |
Excel tip:Create own ribbon tab - Excel 2010a. In Excel click on the File tab |