I hate to ask for help when there is so much available through searching, but I've spent all day looking through other threads, and I'm just not
making it click.
Here is the formula I have:
=IF(ISERROR(VLOOKUP(A12,AC!$A:$B,2,FALSE)=TRUE),VLOOKUP(A12,DC!$A:$B,2,FALSE),VLOOKUP(A12,AC!$A:$B,2,FALSE))
I have three sheets. On sheet one, I have the formula above. The formula pulls data from sheets two and three, labelled AC and DC respectively.
The problem is that depending on the day, there might not be any data on sheets two, three, or both - and it produces an N/A error.
Any way I can add to the above formula so if I get an N/A it shows a blank cell instead?
Thanks so much in advance!
Bookmarks