Duplicate values in different column, associated rows?

[stevebob]

Hi,
I have two different lists and I need to isolate the adjacent columns for similar values between the lists. For example, I need to compare column1 and columnX find the similar values and also isolate the column2 values associated with column1.

column1: column2: columnX:
steve $400 steve
henry $300 henry
frank $300 frank
joe $0 joe

any advice?

Thanks!

 

[doublej_jj]

Not sure if I get the whole idea, but I'll take a stab at it. In cell C1,

=IF(A1=X1,B1,"")

Copy this down to all of the data. The formula says, if what is in Column A is the same as what is in Column X, then give me what is in Column B. Otherwise, do nothing or "".

Good Luck.

Jeff

 

[stevebob]

Not sure if I get the whole idea, but I'll take a stab at it. In cell C1,

=IF(A1=X1,B1,"")

Copy this down to all of the data. The formula says, if what is in Column A is the same as what is in Column X, then give me what is in Column B. Otherwise, do nothing or "".

Good Luck.

Jeff

Hey Jeff, thanks for your response. I tried your trick, but it doesn't seem to work. I think because the values of A and X aren't equal, my lists aren't aligned. Does this make sense?

 

[doublej_jj]

So, some of your values in column A are in Column X, but not all of them. If your value in column A is in column X, then return what is in B?

=if(Iserror(Vlookup(A1,$X$1:$X$1000,1,0)),"",B1)

If you cannot find A1 in column X, do nothing. IF you do find it, bring what's in B1.

Jeff