Hello.
I have done this a thousand times before (well maybe hundreds) w/o issue. However, for some reason I can get anything to return on the following:
=INDEX('Flood Report'!$X$2:$X$15000,MATCH($A22,'Flood Report'!$AN$2:$AN$15000,0))
If I do a CountIf('Flood Report'!$AN$2:$AN$15000,$A22)...