Hi
you already received two working solutions in both
Excel.worksheetfunctions and in this group. Have you tried
them?
If yes what probel did you encounter.

P.S.: please stay in the original thread and do not
multipost this question

-----Original Message-----
Hi,
how to use vlookup that actually select those values in
column A which does not appear in column B and vice versa.

example:
Columns
A B C(From column A) D(From column B)
2.3 1.3 1.2 0.4
1.3 0.4 1.4 2.6
3.6 2.6
1.2 2.3
1.4 3.6


many thanks

regards,
Joey

.