Using INDEX MATCH with table ranges.

[Darranimo]

I have the current 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

 

[AhoyNC]

Since you have Excel 365 you may want to use the FILTER function which will return multiple check numbers.
See example below.

Book2
	A	B	C	D	E	F	G
1		Ceck#	Column1	udVoid			Void Ch
2		100		Void Ch			100
3		101		test			102
4		102		Void Ch			103
5		103		Void Ch
6		104		test
Sheet1

Cell Formulas
Range	Formula
G2:G4	G2	=FILTER(Table1[Ceck'#],Table1[udVoid]=G1,"")
Dynamic array formulas.

 

[Darranimo]

OMG! I was totally unaware of the FILTER function! Thank you, this is perfect!

 

[AhoyNC]

You're welcome. Thanks for the feed back.