• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Need help..

S

sheltan

New Member
I have a list of email ID's on 2 diff columns (Column A & Column B).the requirement is to Vlookup values from ColumnA in Column B and if an exact match is found " the result is to be displayed as keyword "...


The Formula i have used sorts and vlookups the data, the results displayed are either " N/A" or displays the value as available on Culmn A...


I would want to display the result as a keyword rather than wats seen on column A
 
Sheltan "Need help" says nothing about your problem, forum members have different areas of skill in Excel and they also have a busy life away from the board, if they do not see a post title that interests them, such as yours, they will skim by. you need to grab their attention with more descriptive post title.

Just look at other post titles. not many say "Need help", and they will get an answer that is related to their question as others will be able to see if they can help.


Can you use a simple IF statement to match and display?


These links may help you


http://chandoo.org/wp/2012/10/04/formula-forensics-no-030/


http://chandoo.org/forums/topic/sorting-using-vlookup-and-countif
 
You must log in or register to reply here.
Back
Top