If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
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)) |
#2
|
|||
|
|||
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)) |
#3
|
|||
|
|||
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)) |
Thread Tools | |
Display Modes | |
|
|