View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Astro Astro is offline
external usenet poster
 
Posts: 9
Default Trying to compare the datas...

Is there a function I can use for the following:

Sheet1:
A B
1 John OK
2 Mark
3 Dan OK

Sheet2:
A
1 John
2 Dan

So if "John" from Sheet1 can be found in Sheet2 column A, then display OK at
Sheet1 column B Row 1. Can this be done?