I have a sheet that uses vlookup formulas to get data from canned reports exported from a database. The lookup formula finds data based on a project#. I want to be able to record information in a spreadsheet before a database record is created and a project# assigned. This would be done by manually entering information into the spreadsheet, leaving the project# field blank, and then using code to overwrite the manual data once the project# field was populated. I can't think of a way to do this using formulas, as they must be embedded in the cells. Is there a way to write it in code? If I could write it in a formula, the logic would be, =IF(ISBLANK(B1),"leave the data typed",vlookup)
thanks
Bookmarks