IFERROR Function

Hi All,

Hoping to have some assistance with my function in B80 on the Monthly Summary Tab.

If there is no vendor in Column L (in Tab Raw Data), I want the formula to revert to showing the Memo/Description in Column J. I tried using the IFERROR Function and essentially copied the same function in value_if_error but changed the range from L:L to J:J to capture this, but unfortunately it will copy some memo descriptions for row items that do have a vendor.

I would really appreciate some insight into this. Thanks in advance for your help!

Originally Posted by scruz9

I want the formula to revert to showing the Memo/Description in Column J.

Erm.... Which formula?
Might need to provide a little more information than that, and perhaps some expected results might be helpful.

BSB

Hi Buoy,

Apologies if I wasn't clear. But the formula starts in B80 in the monthly summary page.

Essentially if there is no vendor listed, id like for it to return the memo description rather than "0"

Originally Posted by BadlySpelledBuoy

Erm.... Which formula?
Might need to provide a little more information than that, and perhaps some expected results might be helpful.

BSB

If the expected result is a TEXT string, you can just wrap the entire original formula in the T function

=T(yourformula)

Hmm that didn't seem to work. It's only picking up one comment even though there are 2 comments. I've attacehd the most recent workbook.