Vlookup Problem or other Solution needed

Giganews Newsgroups
Subject: Vlookup Problem or other Solution needed
Posted by:  Akiono Wan (akionost…@googlemail.com)
Date: Fri, 18 Jul 2008

Hi,

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
find.

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
Column A
AEntry2    BEntry1    Text I found if vlookup on Column A but not
Column B
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
Akion Wan

Replies