Thread: Lookup Function
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
KG KG is offline
external usenet poster
 
Posts: 33
Default 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.