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 E3
on 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 Sheet1
.
=IFERROR(VLOOKUP(A3,Sheet2!B2:E3,4,FALSE),Sheet1!D3)
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!