I have a comparing problem

  • Thread starter Thread starter patcha
  • Start date Start date
P

patcha

I need to search columns N and Q and when their rows match two given
values(like vlookup2)I want to concatenate the text values in columns A
and C.
 
patcha > said:
I need to search columns N and Q and when their rows match two given
values(like vlookup2)I want to concatenate the text values in columns A
and C.
Click to expand...

Formula for first row:
=IF(AND(N1=value1,Q1=value2),A1&C1,"")
Copy down for other rows.
 
that wont work because say Im looking to match the numbers 25 in column
N and 31 in column Q I need it to serch all of column N and Q and then
when it finds a match concatenate the values in that corisponding row
with the text in A and C
 
Let me try and explain this better.

On some worksheet say 3, I have a certain cell say B20 that is looking
to match the value C20 and D20 from columns N and Q from worksheet 2,
when it finds this match it will concatentate the text values in A and
C in worksheet 2. now the cell below B20 so B21 will do the same thing
only it will look for a match of values in C21 and D21 from the same
columns (N and Q) from worksheet 2.
 
I'd suggest that you rethink the design


=IF(ISNUMBER(MATCH("x",$N$2:N$200,0)),INDIRECT("A"&MATCH("x",$N$2:$N$200,0))
,"")&IF(ISNUMBER(MATCH("y",$Q$2:$Q$200,0)),INDIRECT("C"&MATCH("y",$Q$2:$Q$20
0,0)),"")

if you need both values to be found than you have to chnage the formula and
add the AND function
 
This might be what your looking for

=IF(AND(C20=Sheet2!N20,D20=Sheet2!Q20),Sheet2!A20&Sheet2!C20,""

Enter this formula in cell B20 on worksheet sheet3. This will check if C20 on sheet 3 is equal to N20 on sheet2, and check if D20 on sheet3 is equal to Q20 on sheet2. If they are both true then the formula will return the concatenated value from A20 and C20 on sheet2

Good Luck
Mark Graesse
(e-mail address removed)

----- patcha > wrote: ----

Let me try and explain this better

On some worksheet say 3, I have a certain cell say B20 that is lookin
to match the value C20 and D20 from columns N and Q from worksheet 2
when it finds this match it will concatentate the text values in A an
C in worksheet 2. now the cell below B20 so B21 will do the same thin
only it will look for a match of values in C21 and D21 from the sam
columns (N and Q) from worksheet 2
 
Back
Top