I had problem in retreiving the Data

Closed
bhrmalik Posts 4 Registration date Tuesday September 1, 2009 Status Member Last seen September 3, 2009 - Sep 2, 2009 at 07:19 AM
bhrmalik Posts 4 Registration date Tuesday September 1, 2009 Status Member Last seen September 3, 2009 - Sep 3, 2009 at 01:50 AM
Dear All,

Can anybody help to get the result from column B where no 2 has different values in column A, I want this all details filtered in another cells or sheet. I am using the vlookup but I am getting the same result in the other cells also, I want the different value.

A B
1 2
2 3
3 4
4 2
5 6
6 7
7 2
8 9
9 0
0 2

1 reply

bhrmalik Posts 4 Registration date Tuesday September 1, 2009 Status Member Last seen September 3, 2009
Sep 3, 2009 at 01:50 AM
Dear All,

Can anybody help to get the result from column B where no 2 has different values in column A, I want this all details filtered in another cells or sheet. I am using the vlookup but I am getting the same result in the other cells also, I want the different value.

A B C D
1 2 2 1
2 3 4
3 4 7
4 2 0
5 6
6 7
7 2
8 9
9 0
0 2

Through lookup I am getting the first response of the value means

C D
2 1
1
1
1

Do anybody help me to get the correct answer.
0