Lookup Function

[kg]

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.

 

[Pete_UK]

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

 

[Jacob Skaria]

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

 

[kg]

Yes, it worked! This helped a lot. Thanks so much!