software

Hi

I would like to do the following :

In sheet 2
A1 = quot;SEquot;
B1 = quot;1quot;

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 = quot;SEquot;
B1 = quot;1quot;

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

Thanks

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-Proquot;Bharat Sabooquot; wrote:

gt; Hi
gt;
gt; I would like to do the following :
gt;
gt; In sheet 2
gt; A1 = quot;SEquot;
gt; B1 = quot;1quot;
gt;
gt; In sheet 1 I need to check if the same exists as a combination. In sheet 1
gt; also the data is stored separately like
gt; A1 = quot;SEquot;
gt; B1 = quot;1quot;
gt;
gt; Kindly let me know how to go about it using the vlookup function.
gt;
gt; Thanks