Lookup Function

  • Thread starter Thread starter kg
  • Start date Start date
K

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.
 
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
 
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
 
Back
Top