Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Lookup Function
Hello,
I was wondering if there is a function that would allow me to do the following: I have 2 worksheets (Worksheet A & Worksheet B) on the same workbook. I want to be able to find a value (ex: AB12345 or 12345) in Worksheet A from a column in Worksheet B. If the value is the same, return "YES" and if there is no match for that value, then return "NO." I hope someone can help... thanks in advance. kg. |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Lookup Function
Suppose your list is in column A of sheetB, and that A1 in sheetA
contains the value you want to check. Put this in B1 of sheetA: =IF(ISNA(MATCH(A1,SheetB!A:A,0)),"No","Yes") Hope this helps. Pete On Aug 19, 6:33*pm, kg wrote: Hello, I was wondering if there is a function that would allow me to do the following: I have 2 worksheets (Worksheet A & Worksheet B) on the same workbook. *I want to be able to find a value (ex: AB12345 or 12345) in Worksheet A from a column in Worksheet B. *If the value is the same, return "YES" and if there is no match for that value, then return "NO." I hope someone can help... thanks in advance. kg. |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Lookup Function
The below formula from sheet 1 will check in Sheet2 ColA and return yes if
Ab1234 is present ; else returns no =IF(COUNTIF(Sheet2!A:A,"Ab1234"),"Yes","No") If this post helps click Yes --------------- Jacob Skaria "kg" wrote: Hello, I was wondering if there is a function that would allow me to do the following: I have 2 worksheets (Worksheet A & Worksheet B) on the same workbook. I want to be able to find a value (ex: AB12345 or 12345) in Worksheet A from a column in Worksheet B. If the value is the same, return "YES" and if there is no match for that value, then return "NO." I hope someone can help... thanks in advance. kg. |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
Lookup Function
Yes, it worked! This helped a lot. Thanks so much!
"Jacob Skaria" wrote: The below formula from sheet 1 will check in Sheet2 ColA and return yes if Ab1234 is present ; else returns no =IF(COUNTIF(Sheet2!A:A,"Ab1234"),"Yes","No") If this post helps click Yes --------------- Jacob Skaria "kg" wrote: Hello, I was wondering if there is a function that would allow me to do the following: I have 2 worksheets (Worksheet A & Worksheet B) on the same workbook. I want to be able to find a value (ex: AB12345 or 12345) in Worksheet A from a column in Worksheet B. If the value is the same, return "YES" and if there is no match for that value, then return "NO." I hope someone can help... thanks in advance. kg. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Combining Lookup function and Sum function | Excel Worksheet Functions | |||
LOOKUP FUNCTION? (LOOKUP VALUE BEING A TIME RENERATED FROM A FORMU | Excel Discussion (Misc queries) | |||
Excel Data Validation/Lookup function does function correcty | Excel Worksheet Functions | |||
how to combine an IF Function with a lookup function to determine | Excel Worksheet Functions | |||
Pivot table doing a lookup without using the lookup function? | Excel Discussion (Misc queries) |