# match with isna formula question

B

#### Belinda7237

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

D

#### Duke Carey

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

B

#### Belinda7237

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 said:
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 said:
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))