IF? Vlookup?

[Mistry]

I have 3 bits of data.

Col1 Col2 Col3

Row 1 EC QWERTY POIUY
Row 2 ZXCVB QWERTY

What i want to do is if Col2 data ( ROW 1 QWERTY equals data in row 2
col3 and ROW1 equals EC then i want EC-X to be displayed in Col1 Row 2

 

[James Ravenswood]

In B2 enter:
=IF(AND(B1=C2,A1="EC"),"EC-X","")

 

[Mistry]

In B2 enter:
=IF(AND(B1=C2,A1="EC"),"EC-X","")

Thanks -

I just realsied that the example i gave would be ok if it was just a
couple of lines -.

i need it to check the entire colum to see if any of the data matches
and it so provide a EC-x in the apporporiate col so in the example
below. Row 2
Col1 Col2 Col3


Row 1 EC QWERTY POIUY
Row 2 (EC-x) ZXCVB QWERTY
RO3 EC lkjhg ZXCVB
.....
Row 4 (EC-x) rtyui QWERTY
Ro4 (EC-X) asdfg lkjhg