This is actually pretty powerful, and I've been scouring the web for a while to get this question answered. In my case, however, I don't want to replace the
#N/A with a
0, but instead, I want to use alternate information. In my case, if the
VLOOKUP doesn't find anything, I want it to use the contents of another cell. (I'm using Excel 2010, but that shouldn't matter) Assume that my formula in cell
Sheet1, and the data I want to pull is somewhere on
Sheet2. If there is no data to be found on
Sheet2, then I want my cell to use data from
To the original responder, THANK YOU. You made my life a bit easier tonight. I hope my rambling expansion on your answer helps someone, too!