Select the list of country names and the formula result (cells A2 to B11 in our example).Copy the formula down to the last country name in the list. The purpose of the formula is to calculate 1 if cell D2 is the same as the country in column A otherwise, #N/A is displayed. Here are those steps in more detail Formula to calculate as 1 or #N/AĮnter a country name in a cell (for our example, use cell D2).Ĭolumns A contains the names of countries.Įnter the following formula in cell B2: =IF(VLOOKUP(A2,$D$2,1,0)=A2,1,NA()) #Set up a header to appear on all sheets for excel series#
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |