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
|