excel 2003 visual basic intermediate course - 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