editing formula's in lots of cells

[r.baldwin7960]

I'm using VLOOKUP to pull data from a web query to a report page, the "new" table is 21 rows by 96 columns.

The formula that I am using is:

=IF($B7="","",VLOOKUP($B7,'Sheet2'!$E$7:$CV$47,2,FALSE))

I need to change it to:

=IF(ISERROR(IF($B7="","",VLOOKUP($B7,'Sheet2'!$E$7:$CV$47,2,FALSE))),"",IF($B7="","",VLOOKUP($B7,'Sheet2'!$E$7:$CV$47,2,FALSE)))

The problem is that I can't (or don't know how to) use the Replace command to do this on all the cells at once (about 20,000 by my calculations)

Can I use a macro to do this? If so, how would I write it?

Thanks for all the help again!

 

[r.baldwin7960]

Actually, I figured out a different way to take care of my issue. So thank you anyway.

---Closed