Interview Question

Thursday, July 18, 2013

How to check data in two column in Execl?


=IF(ISNA(VLOOKUP(A1,$B$1:$B$65535,1,FALSE)),"Not in B","Exists In B")
Posted by Sahil Singh at 4:32 AM
Email ThisBlogThis!Share to XShare to FacebookShare to Pinterest

No comments:

Post a Comment

Newer Post Older Post Home
Subscribe to: Post Comments (Atom)

Blog Archive

  • ►  2017 (4)
    • ►  April (1)
    • ►  February (1)
    • ►  January (2)
  • ►  2016 (11)
    • ►  October (1)
    • ►  July (3)
    • ►  May (2)
    • ►  March (2)
    • ►  February (3)
  • ►  2015 (31)
    • ►  December (3)
    • ►  November (2)
    • ►  October (1)
    • ►  September (2)
    • ►  July (7)
    • ►  June (10)
    • ►  May (2)
    • ►  April (1)
    • ►  February (2)
    • ►  January (1)
  • ►  2014 (96)
    • ►  December (1)
    • ►  October (11)
    • ►  September (1)
    • ►  August (2)
    • ►  July (6)
    • ►  June (5)
    • ►  May (10)
    • ►  April (16)
    • ►  March (21)
    • ►  February (2)
    • ►  January (21)
  • ▼  2013 (117)
    • ►  December (14)
    • ►  November (1)
    • ►  October (12)
    • ►  September (6)
    • ►  August (7)
    • ▼  July (3)
      • How to check data in two column in Execl?
      • How to get Top N result From Linq?
      • How to get top N Result from dataview or datatable...
    • ►  June (21)
    • ►  May (15)
    • ►  April (10)
    • ►  March (12)
    • ►  February (11)
    • ►  January (5)
  • ►  2012 (11)
    • ►  December (11)

About Me

My photo
Sahil Singh
Sahil singh is a Senior Software Engineer in UK based company.
View my complete profile
Posted by: Sahil Singh. Picture Window theme. Theme images by 5ugarless. Powered by Blogger.