Thread: Function Help
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Erika Erika is offline
external usenet poster
 
Posts: 120
Default Function Help

I keep getting an error with a formula that I am working with. When I build
the formula through the Function Wizard I can see the result but when I click
on OK I get a Value Error.

Here is the formula

=IF(ISNA(INDEX($C$37:$C$118,MATCH($A9&C$7,$A$37:$A $98&$B$37:$B$118,0))),0,INDEX($C$37:$C$118,MATCH($ A9&C$7,$A$37:$A$118&$B$37:$B$118,0)))

What am I missing?