match error

[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.

 

[Bob Phillips]

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

 

[Bob Phillips]

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]

thanks, this worked perfectly! Appreciate your help!

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)

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.