I have the current formula:
I am trying to return the check numbers from a table if column "udVoid" is true but it doesn't return anything. Cell D4 has the text "Void Ch" which is what appears in the column "udVoid" and I'm trying to match to. Am I not able to select a table range like I did with INDEX MATCH? I was hoping to avoid writing some script for this but maybe that's what I should do. Any advice or help would be greatly appreciated.
Sincerely,
A Lazy Accountant
Excel Formula:
=IFERROR(INDEX(tblGL[@[udCheckNo]:[udVoid]],1,MATCH($D$4,tblGL[udVoid],0)),"")
I am trying to return the check numbers from a table if column "udVoid" is true but it doesn't return anything. Cell D4 has the text "Void Ch" which is what appears in the column "udVoid" and I'm trying to match to. Am I not able to select a table range like I did with INDEX MATCH? I was hoping to avoid writing some script for this but maybe that's what I should do. Any advice or help would be greatly appreciated.
Sincerely,
A Lazy Accountant