- You are here
- Microsoft Newsgroups Archived.At
- microsoft.public.excel
- 2008 July
- Vlookup Problem or other Solution needed

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

- RE: Vlookup Problem or other Solution needed posted by Billy Liddel on Fri, 18 Jul 2008
- Re: Vlookup Problem or other Solution needed posted by Dave Peterson on Fri, 18 Jul 2008