use of vlookup in case of multiple column check
 

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

use of vlookup in case of multiple column check
 

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


"Bharat Saboo" wrote:

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