jumbel
08-28-2008, 04:30 AM
Hey,
I know th concept of Vlookup, but I need to implement this Vlookup functionality 3 times. for example..
lets say i have four columns with the following values.
A B C D
1 3 4 3
2 4 5 3
2 5 6 7
1 3 6 5
3 6 7 7
3 4 6 1
Now, I need to display the values of D accordingly in another sheet by looking at the values of A, B and C.
With Vlookup, i get the value of D for A1 and A4 both as 3. But, I need to find way by looking at column A first and if the same value exists in the column A again, then looking at B and if a similar value exists in Column B, then look at column C and then display the value of D.
I hope i explained the issue correctly.Please help!!!
I know th concept of Vlookup, but I need to implement this Vlookup functionality 3 times. for example..
lets say i have four columns with the following values.
A B C D
1 3 4 3
2 4 5 3
2 5 6 7
1 3 6 5
3 6 7 7
3 4 6 1
Now, I need to display the values of D accordingly in another sheet by looking at the values of A, B and C.
With Vlookup, i get the value of D for A1 and A4 both as 3. But, I need to find way by looking at column A first and if the same value exists in the column A again, then looking at B and if a similar value exists in Column B, then look at column C and then display the value of D.
I hope i explained the issue correctly.Please help!!!