I have a formula that the newsgroup help me with over a year ago. It worked
perfectly and I use it though out my programs. However I want to use it in a
similar situation and I cannot get it to work. The formula returns #num. it
should return 723,314.70

The range name is alabamasort. It is all in 1 worksheet different tabs.
I want the formula to look in the range name alabamasort find TAX BILLED in
column 1 and TOTAL in column 2 and return the value in column 4

The columns are as follows:
Type City/County State amount

Taxble sales cottonwood al 1,303.14
TAX BILLED TOTAL AL 723,314.70

This is the formual

=IF(ISNA(INDEX(alabamasort,MATCH(1,(INDEX(alabamas ort,,1)=" TAX
BILLED")*(INDEX(alabamasort,,2)="TOTAL"),0),4)),0, INDEX(alabamasort,MATCH(1,(INDEX(alabamasort,,1)=" TAX BILLED")*(INDEX(alabamasort,,2)="TOTAL"),0),4))

Can you help?