Thread: match error
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Belinda7237 Belinda7237 is offline
external usenet poster
 
Posts: 106
Default match error

I am getting an error with my formula and wondering if its just punctuation?

=IF(ISNA(MATCH,(F14,'[Bundled Report 07-08.xls]CAU - Maturing
Loans'!$F:$F,0,)""(INDEX('[Bundled Report 07-08.xls]CAU - Maturing
Loans'!$A:$A,MATCH,'[Bundled Report 07-08.xls]CAU - Maturing
Loans'!$F:$F,0),1)))

I want to lookup F14 in my current report and match it to my 0708 report -
if there is a mtach i want it to return the value in column A (which is text)
and if it doesnt match I dont want it to do anything.