Forum home » Delegate support and help forum » Microsoft Excel Training and help » excel 2003 visual basic intermediate course - Excel vlookup if statements
|
|
|
The UK's most regular 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 2003 visual basic intermediate course - Excel vlookup if statements
Resolved · Low Priority · Version Standard
Reply Wed 5 Dec 2007, 11:29Delegate Frances said...
Frances has attended:
Visio Introduction course
Excel vlookup if statements
Can you use Vlookup within an IF statement?
For upcoming training course dates see: Pricing & availability
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
|