|Subject:||Vlookup Problem or other Solution needed|
|Posted by:||Akiono Wan (akionost…@googlemail.com)|
|Date:||Fri, 18 Jul 2008|
my Problem is that I have got a table in which Columns A and B
together are the primary key for Column C, which I want to refer to.
I tried to use vlookup but I can lookup only on one Column therefore I
found only the first hit but not the right reference, I would like to
Here an Example
Column A Column B Column C
AEntry1 BEntry1 Text I found if vlookup on Column B or Column A
AEntry1 BEntry2 Text I found if vlookup on Column B but not on
AEntry2 BEntry1 Text I found if vlookup on Column A but not
AEntry2 BEntry2 Text I never found
I would like an vlookup over both Columns A and B to get Column C.
Is there any approach with vlookup or should I use something else?
Thanks for Help