how to do multiple vlookups?

[jumbel]

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!!!

[Aussiebear]

And if it is not a match in either A1, B1 or C1?

[jumbel]

if the same value doesnt exist then directly display the corresponding value of D....

[jumbel]

its like having a list of names....if the same name appears in the column then we check the second criteria....hope u understood the concept...

[Bob Phillips]

Are you saying that you will have three numbers somewhere, and if the first is matched more than once in column A then check the second against column B as well, and if the first and second matches more than once in columns A & B, continue this process with column C as well,

OR

do you mean that you ALWAYS want to match three numbers against A, B and C columns?

[jumbel]

I mean the first case you are referring to.