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

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

.