match error

  • Thread starter Thread starter Belinda7237
  • Start date Start date
B

Belinda7237

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.
 
=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))

--
HTH

Bob

(there's no email, no snail mail, but somewhere should be gmail in my addy)
 
Just noticed another of your errors

=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(F14,'[Bundled
Report 07-08.xls]CAU - Maturing Loans'!$F:$F,0),1))

If you struggle using long formula, build them in separate cells, like this

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

--
HTH

Bob

(there's no email, no snail mail, but somewhere should be gmail in my addy)
 
thanks, this worked perfectly! Appreciate your help!

Bob Phillips said:
Just noticed another of your errors

=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(F14,'[Bundled
Report 07-08.xls]CAU - Maturing Loans'!$F:$F,0),1))

If you struggle using long formula, build them in separate cells, like this

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

--
HTH

Bob

(there's no email, no snail mail, but somewhere should be gmail in my addy)

Belinda7237 said:
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.
Click to expand...
Click to expand...
 
Back
Top