Need a code to insert formula if a cell has data

[katkth7533]

Hi there! Is there a way to insert a code/ formula so that I will get a result IF there is data in another cell? Right now, the formula gives me an error message when one of the fields is empty. In my example, I have a vlookup formula in cell C24 [=VLOOKUP(BQ24;CE8:CF41;2)] but cell BQ24 may not always have data in it. Cell C24 is part of a range that has this vlookup formula in it (with BQ24 being renamed for different cells) and totals to another cell (cell AA1). If BQ24 is blank, I get an error message (#N/A) in cell AA1. I am trying to overcome the error message in case BQ24 has no data without having to add or delete the vlookup formula every time.