matching more than one column

[csgraves]

I am trying to match multiple columns. I have data in columns c&h, there are 23000 rows and I want to find an exact match in columns s&v and there are 1200 rows in these columns.

example


column a column c column h column n column s column v

agent number last name last 4 of social ? last name last 4 of social


if the columns find an exact match, I want to return the value in column A in column n which is an agent number to go with columns s&v.

Just got stuck and can't fine a solution.

Thanks for any help.

Scott

 

[mrshl9898]

Like this?

=IF(C2&H2=S2&V2,A2,"")

 

[csgraves]

I tried this...this just compares the specific cells labels c2, h2, s2 and v2. I need it to compare the list and search for like names and enter the agent number. Any ideas?

thanks for your help

 

[Fluff]

Maybe
=IFERROR(INDEX(A$2:N$23000,MATCH(1,INDEX((S$2:S$1200=C2)*(V$2:V$1200=H2),0),0),1),"")

 

[csgraves]

I can't seem to get those to work, but thanks everyone.

I need something like this, but not sure how to write the formula:

Compare column H2:H23000 to column S2:1200, if exact match, return number in column A for that match in those columns

Any ideas?

Thanks!

Scott

 

[Fluff]

How about
=IFERROR(INDEX(A$2:A$23000,MATCH(H2,S$2:S$1200,0),1),"")

 

[csgraves]

How about
=IFERROR(INDEX(A$2:A$23000,MATCH(H2,S$2:S$1200,0),1),"")

But how do I make it search H2:H23000 and not just H2?

 

[Fluff]

Copy the formula down