Vlookup+IsError Compbination For Baby Names

Excel function tutorials

If you want to learn Excel, keep reading or Get 10 days of free unlimited access to Lynda.com. for professional help and Excel Tutorials
***************

One of the very real examples that I’ve had in the past few months is trying to find baby names which as you can imagine means looking at a bunch of lists, discussing, etc. My wife and I have a few different “criterias” and one of them is having a name is would also be “fairly common” in both the UK and Canada where we might end up living at some point.

So I downloaded the list of the top names used in 2013 in all 3 countries as you can see here. I’ll start by looking at all of the US names to see if they are part of the top 100 names in both Canada and the US. How?

Let’s start with the first name, I’ll simply add next to it:

=VLOOKUP(A2,E:F,2,FALSE)

Now I’d like to replace the 0 by 1 and the #N/A by 0… so I’ll do:

=IF(ISERROR(VLOOKUP(A2,E:F,2,FALSE)),0,1)

Then I’ll simply add the reference to Canada as well:

=IF(ISERROR(VLOOKUP(A2,E:F,2,FALSE)),0,1)+IF(ISERROR(VLOOKUP(A2,G:H,2,FALSE)),0,1)

To make it more clear, I’ll then add a condition:

=IF(IF(ISERROR(VLOOKUP(A2,E:F,2,FALSE)),0,1)+IF(ISERROR(VLOOKUP(A2,G:H,2,FALSE)),0,1)=2,”Yes”,””)

Then I could add a filter to get the list of names that fit the critera:

***************************************************

Look Good at Work and Become Indispensable Become an Excel Pro and Impress Your Boss


***************************************************

One Feedback on "Vlookup+IsError Compbination For Baby Names"

currentevents.pw

continuously i used to read smaller content that also clear their motive, and that is also happening
with this piece of writing which I am reading at this place.



Comments

Please Leave a Comment!





Please note: Comments may be moderated. It may take a while for them to show on the page.