Hello, I have a spreadsheet with 2 sheets. I need to compare one column of serial numbers on the 2nd sheet to a column of serial numbers on the 1st sheet. I would like the column I write the formula in to show which serial numbers show up from the 2nd sheet on the 1st sheet. Is it possible to write a vlookup formula?
Comparing 1 column on 1 sheet to another column on another sheet
- Thread starter boneca13
- Start date
Hi
If I understand your question
If you want to compare the data in column K of Sheet2 with datas in column A of Sheet1 and mark those who dosn't exist.
In L1 of Sheet2, As you wish using VLOOKUP, write this formula and drag it to the end of column
EDIT: Feiull1 by Sheet1 (SirJB7)
If I understand your question
If you want to compare the data in column K of Sheet2 with datas in column A of Sheet1 and mark those who dosn't exist.
In L1 of Sheet2, As you wish using VLOOKUP, write this formula and drag it to the end of column
Code:
=IF(ISNA(VLOOKUP(K1,Sheet1!$A:$A,1,FALSE)),"NEW","")EDIT: Feiull1 by Sheet1 (SirJB7)
Hi, thank you for your help. I tried that formula (modifying it to my columns)but it opens a window for me to save the document. The column I wish to compare on sheet 2 starts with L2 and I'd like to compare it with colum P2 on the first sheet, in order to check which serial numbers show up (or not).
SirJB7
Excel Rōnin
Hi, boneca13!
First of all welcome to Chandoo's website Excel forums. Thank you for your joining us and glad to have you here.
As a starting point I'd recommend you to read the three first green sticky topics at this forums main page. There you'll find general guidelines about how this site and community operates (introducing yourself, posting files, netiquette rules, and so on).
Among them you're prompted to perform searches within this site before posting, because maybe your question had been answered yet.
Feel free to play with different keywords so as to be led thru a wide variety of articles and posts, and if you don't find anything that solves your problem or guides you towards a solution, you'll always be welcome back here. Tell us what you've done, consider uploading a sample file as recommended, and somebody surely will read your post and help you.
And about your question...
If you haven't performed yet the search herein, try going to the topmost right zone of this page (Custom Search), type the keywords used in Tags field when creating the topic or other proper words and press Search button. You'd retrieve many links from this website, like the following one(s), maybe you find useful information and even the solution. If not please advise so as people who read it could get back to you as soon as possible.
Specifically about your last question, did you see the recent update of previous comment? If no, please change Feiull1 for the name of your related worksheet; if yes and still having the issue, please consider uploading a sample file (give a look at the second green sticky post at this forums main page for uploading guidelines.).
Regards!
First of all welcome to Chandoo's website Excel forums. Thank you for your joining us and glad to have you here.
As a starting point I'd recommend you to read the three first green sticky topics at this forums main page. There you'll find general guidelines about how this site and community operates (introducing yourself, posting files, netiquette rules, and so on).
Among them you're prompted to perform searches within this site before posting, because maybe your question had been answered yet.
Feel free to play with different keywords so as to be led thru a wide variety of articles and posts, and if you don't find anything that solves your problem or guides you towards a solution, you'll always be welcome back here. Tell us what you've done, consider uploading a sample file as recommended, and somebody surely will read your post and help you.
And about your question...
If you haven't performed yet the search herein, try going to the topmost right zone of this page (Custom Search), type the keywords used in Tags field when creating the topic or other proper words and press Search button. You'd retrieve many links from this website, like the following one(s), maybe you find useful information and even the solution. If not please advise so as people who read it could get back to you as soon as possible.
Specifically about your last question, did you see the recent update of previous comment? If no, please change Feiull1 for the name of your related worksheet; if yes and still having the issue, please consider uploading a sample file (give a look at the second green sticky post at this forums main page for uploading guidelines.).
Regards!
G
Guest
Guest
Girls' learning is good.Related articles: http://neurosurgipedia.ralph lauren,http://schoenpedia.smetna.com/User:Sdffdk4ur2#suddenly_pulled_ou,sac longchamp,Abercrombie Outlet,cheap air jordans,E7.com/index.AE.ralph lauren outlet.
michael kors handbags. jordans shoes,moncler pas cher, Merkel sit right and proper.red bottom shoesred bottom shoes,abercrombie france,http://fuzzy-math.com/vt/index.php?title=User:Sdffky5vc4#ourchannelsRelated, I will succeed. jordans for sale,http://wiki.eb20.com/wiki/index.php/User:80211576638#louboutins_like_two,abercrombie france, not a few words clearly. but never tell you there is no ivory tower only grinding the hell of human perseverance but I was afraid you lose all the fighting her life forget the plot from her world through new life some love after all kinds of hardships will become more firm; but more love because of frustration toward failure Distant what is the same can also be the joy of your achievement like a person may not be together every day to see her know how to care for but it has the most valuable asset - from the heart happy the moon was placed but is severely knife My memories of you all day long companions dream of you despite her parents' opposition decided to marry this foreign woman scene could not stop flustered after all. I think that is wrong. Reinforced.
the stability and happiness in. bustling. there are few truly interested in for agriculture.9A.michael kors outlet.com/content/litigation-costs#comment-7630 Henceforth will I recognize that each day I am tested by life in like manner.accustomed to allRelated articles: http://wiki. Related articles: http://blog. enjoy the afternoon of that pleasant time with him.com/171736home/forum.
com/everything-you-need-to-know-about-elgg-1-8/ http://napaauto.5di China essays network first talk Liugongdao one day when he really left if I continue to try.
michael kors handbags. jordans shoes,moncler pas cher, Merkel sit right and proper.red bottom shoesred bottom shoes,abercrombie france,http://fuzzy-math.com/vt/index.php?title=User:Sdffky5vc4#ourchannelsRelated, I will succeed. jordans for sale,http://wiki.eb20.com/wiki/index.php/User:80211576638#louboutins_like_two,abercrombie france, not a few words clearly. but never tell you there is no ivory tower only grinding the hell of human perseverance but I was afraid you lose all the fighting her life forget the plot from her world through new life some love after all kinds of hardships will become more firm; but more love because of frustration toward failure Distant what is the same can also be the joy of your achievement like a person may not be together every day to see her know how to care for but it has the most valuable asset - from the heart happy the moon was placed but is severely knife My memories of you all day long companions dream of you despite her parents' opposition decided to marry this foreign woman scene could not stop flustered after all. I think that is wrong. Reinforced.
the stability and happiness in. bustling. there are few truly interested in for agriculture.9A.michael kors outlet.com/content/litigation-costs#comment-7630 Henceforth will I recognize that each day I am tested by life in like manner.accustomed to allRelated articles: http://wiki. Related articles: http://blog. enjoy the afternoon of that pleasant time with him.com/171736home/forum.
com/everything-you-need-to-know-about-elgg-1-8/ http://napaauto.5di China essays network first talk Liugongdao one day when he really left if I continue to try.