match with isna formula question
 

I want to bridge info from one workbook to a new workbook with a formula in
column V. but i have two criteria instead of one to consider the match before
bringing over.

column J column I column U
0000557811 357 data to bridge over

Here is my existing formula but it only considers column J and i need both J
and I actually be considered a match

=IF(ISNA(MATCH(J1,'[Bundled Report 07-08.xls]CAU €“ Maturing
Loans'!$J:$J,0)),"",INDEX('[Bundled Report 07-08.xls]CAU €“ Maturing
Loans'!$U:$U,MATCH(J1,'[Bundled Report 07-08.xls]CAU €“ Maturing
Loans'!$J:$J,0),1,0))

match with isna formula question
 

you can MATCH on 2 values against 2 lookup columns by using an array formula
(entered by pressing Ctrl-Shift-Enter)

For example

=MATCH(A1&A2,A5:A20&B5:B20,0)

If A1 contains George & A2 contains Bush, and A5:B20 contains a series of
first names & last names, that formula will look for "GeorgeBush" against
each rows' combined first & last names


"Belinda7237" wrote:

I want to bridge info from one workbook to a new workbook with a formula in
column V. but i have two criteria instead of one to consider the match before
bringing over.

column J column I column U
0000557811 357 data to bridge over

Here is my existing formula but it only considers column J and i need both J
and I actually be considered a match

=IF(ISNA(MATCH(J1,'[Bundled Report 07-08.xls]CAU €“ Maturing
Loans'!$J:$J,0)),"",INDEX('[Bundled Report 07-08.xls]CAU €“ Maturing
Loans'!$U:$U,MATCH(J1,'[Bundled Report 07-08.xls]CAU €“ Maturing
Loans'!$J:$J,0),1,0))

match with isna formula question
 

so using the two columns ad two values I wrote this:

=IF(ISNA(MATCH(I2&J2,'Projected MCE Report Northern
C'!I:J,0)),"",INDEX('Projected MCE Report Northern
C'!U:U,MATCH(I2&J2,'Projected MCE Report Northern C'!I:J,0),1,0))

but it doesn't work - is there something i am doing incorrectly?

"Duke Carey" wrote:

you can MATCH on 2 values against 2 lookup columns by using an array formula
(entered by pressing Ctrl-Shift-Enter)

For example

=MATCH(A1&A2,A5:A20&B5:B20,0)

If A1 contains George & A2 contains Bush, and A5:B20 contains a series of
first names & last names, that formula will look for "GeorgeBush" against
each rows' combined first & last names


"Belinda7237" wrote:

I want to bridge info from one workbook to a new workbook with a formula in
column V. but i have two criteria instead of one to consider the match before
bringing over.

column J column I column U
0000557811 357 data to bridge over

Here is my existing formula but it only considers column J and i need both J
and I actually be considered a match

=IF(ISNA(MATCH(J1,'[Bundled Report 07-08.xls]CAU €“ Maturing
Loans'!$J:$J,0)),"",INDEX('[Bundled Report 07-08.xls]CAU €“ Maturing
Loans'!$U:$U,MATCH(J1,'[Bundled Report 07-08.xls]CAU €“ Maturing
Loans'!$J:$J,0),1,0))