E
Eliah
I am trying to cross reference several sheets of data to be sure that the
proper numbers are pulled back to my main sheet. The only common column that
exists is name, however, some have the name as "Smith, John" and some as
"Smith, John;Smith, Mary" My current if(isna(vlookup) attempt seems to work
for rows where there is only 1 person (no ;Smith, Mary) it does not find
data if there are 2 names. I can't figure out how to match up on the second
name. Any suggestions?
Currently my formula looks like this
=if(isna(vlookup(Mainsheetcolumn1entry!A5,SecondaryworksheetrangeD$2:1$300,6,false)),0,vlookup(Mainsheetcolumn1entry!A5,SecondaryworksheetrangeD$2:1$300,6,false))
proper numbers are pulled back to my main sheet. The only common column that
exists is name, however, some have the name as "Smith, John" and some as
"Smith, John;Smith, Mary" My current if(isna(vlookup) attempt seems to work
for rows where there is only 1 person (no ;Smith, Mary) it does not find
data if there are 2 names. I can't figure out how to match up on the second
name. Any suggestions?
Currently my formula looks like this
=if(isna(vlookup(Mainsheetcolumn1entry!A5,SecondaryworksheetrangeD$2:1$300,6,false)),0,vlookup(Mainsheetcolumn1entry!A5,SecondaryworksheetrangeD$2:1$300,6,false))