I have a VLOOKUP on Sheet1. I would like to use a conditional on the
result of the VLOOKUP and insert the result into a cell in either
Sheet2 or Sheet3 (depending on the result of the conditional). I
would like to have a all the work done on Sheet1 and not have to put
any functions on Sheet2 or Sheet3.

Any ideas on how I can do this?

John