Hi
try
=IF(ISNA(MATCH(A1,'sheet2'!A1:A1000,0)),"no match for column
A",IF(ISNA(MATCH(B1,'sheet2'!B1:A1000,0)),VLOOKUP( A1,'sheet2'!A1:B1000,
2,0),""))

--
Regards
Frank Kabel
Frankfurt, Germany

Thanks Frank, I just thought about my post again and it doens't make
any sense to at all! So, I am re-posting my question:

I have 2 columns I want to lookup in sheet 1 against another 2
columns
in sheet 2. In sheet 1, the first column is truncated to the last 6
figures of the 2nd column, same for sheet 2. If column1 in sheet 1
is
found in column 1 of sheet2, and column 2 in sheet 1 is same as
column
2 in sheet2, then it should return "". If column 1 of sheet 1 is
same
as column 1 of sheet, but the columns2 are different, it should give
me the value of column 2 in sheet 2.

I hope you can help me out.

Thanks a lot.


RichardO.


---
Message posted from http://www.ExcelForum.com/