Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Number format | Excel Discussion (Misc queries) | |||
How can i change this VBA project According to Indian Numeric | Excel Discussion (Misc queries) | |||
Amount or Numbers in Words | New Users to Excel | |||
Is there a formula to spell out a number in excel? | Excel Worksheet Functions | |||
Identifying the Active Fill Color | Excel Discussion (Misc queries) |