P
PAL
I have two worksheets. The first one is a list of countries (~25 countries;
LOV!A1:A25) down one column.
The second one is a a multi-column, multi-row list, with one of the columns
being country. I have inserted a another column in order to create regions
for each row.
Example:
If B5=USA, I want it to return, "North America"...
If B5=Canada, I want it to return, "North America"
If B5=Spain, I want it to return, "Europe"
IF B6=Japa, I want it to return, "Asia"
Seems like this is a complex if, but not able figure it out.
LOV!A1:A25) down one column.
The second one is a a multi-column, multi-row list, with one of the columns
being country. I have inserted a another column in order to create regions
for each row.
Example:
If B5=USA, I want it to return, "North America"...
If B5=Canada, I want it to return, "North America"
If B5=Spain, I want it to return, "Europe"
IF B6=Japa, I want it to return, "Asia"
Seems like this is a complex if, but not able figure it out.