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

Advertisements

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
 
Ad

Advertisements

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

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top