I have a match formula that i can't seem to get entered correctly. i am converting this from a lotus spreadsheet to an Excel spreadsheet. I attached a file so you can see the formula in action. i should be getting 14.2 in cell B3.
If someone can look at the formula and see my problem here it is.
Thanks,
![]()
=IF(C44=0,0,INDEX(SETUP,(MATCH(+D89,'Setup Data'!B15:B44,0)-1)+1,(MATCH(D88,'Setup Data'!C14:F14,0)-1)+1))
Bookmarks