"tettrick" wrote...
....
I arranged the data in the cells based on the way I understood your
directions: I placed the two sets of data into two columns (A and B)
instead of four columns as I had them originally. I put the countries
from both lists in column A, placing the group with numbers in rows A1
through A20 and placing the group of countries’ names from the group
with the percentages into rows A21 through A40. In column B, I placed
the each country’s corresponding number in cells B1 through B20 and
the percentages in B21 though B40. Then I tried copying and pasting
the formula you labeled “C1” into cell C1, but I got a “#NAME?”
error. I copied this formula down column C through cell C20, and saw
the same “#NAME?” error in each of the cells.
....

No.

What I meant was that you have 2 tables to begin with. One has numbers, the
other percentages. Name the former NTBL and the latter PTBL. *YOU* have to
do that first. Then you have to decide how you want the results listed. It'd
be simplest to copy one or the other preexisting tables and use it as the
starting point. I'll assume you copy NTBL, which *YOU* should have already
named, into another worksheet with the first cell of the copied table in
that worksheet's A1 cell. NOTE: AT THIS POINT YOU SHOULD HAVE COPIED *ONE*
**AND** **ONLY** *ONE* TABLE.

Next, I meant that you should supplement that copied table with data from
the other table, PTBL, which *YOU* should have already named. You should
have country name in col A and numbers of cell phones in col B. You now add
percentage cell phone penetration in col C using formulas like

C1:
=IF(COUNTIF(INDEX(PTBL,0,1),A1),VLOOKUP(A1,PTBL,2, 0),"")

Note: this will (and **SHOULD**) return #NAME? error if *YOU* haven't named
that table PTBL. If you don't want to name the other table PTBL, then
replace PTBL in the formula above with the range address of the percentages
table.

This will show percentages for the country in col A if that country has an
entry in the PTBL table. Otherwise it'll display nothing.

Then you need to supplement the table with extra rows for the countries in
PTBL that aren't in NTBL. You do that using the other formulas I provided.
Those formula will also return #NAME? if *YOU* haven't named the percentages
table PTBL. Same comments as above.