use of vlookup in case of multiple column check

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Bharat Saboo - 31 Dec 2005 10:34 GMT

Hi

I would like to do the following :

In sheet 2
A1 = "SE"
B1 = "1"

In sheet 1 I need to check if the same exists as a combination. In sheet 1
also the data is stored separately like
A1 = "SE"
B1 = "1"

Kindly let me know how to go about it using the vlookup function.

Thanks

Reply to this Message

Ron Coderre - 31 Dec 2005 16:12 GMT

If you are only trying to match A1 and B1 on sheets 1 and 2....try this:

Using Sheet2:
A1: SE
B1: 1
C1: =AND(A1=Sheet1!A1,B1=Sheet1!B1)

If the upper/lower case matters:
C1: =AND(EXACT(A1,Sheet1!A1),B1=Sheet1!B1)

If you need something else, please post back and give us some additional
data examples.

Does that help?

***********
Regards,
Ron

XL2002, WinXP-Pro

> Hi
>
[quoted text clipped - 12 lines]
>
> Thanks

Reply to this Message