IF Cells in a row Contains..

[mumsys]

Hi,
could you help me with the formula to:

1) find in a certain column some of text f.e (like in attachment) - Brazil and in a different column put America.

There are a lot of countries and data and i want to have it sorted by continents. Macro should look at what text is in a row and change it by the specified rule till the end of rows

Thx

[TMS]

You would use VLOOKUP for that but it isn't obvious which cell has the Country lookup data and which cell has the Continent returned.

But, something like:

=IFERROR(VLOOKUP(A1, $B$4:$C$12, 2, FALSE),"")

... where cell A1 has the Country name.

Regards, TMS

[mumsys]

Oh ok thx, but there is a problem, and maybe i wasnt clear enough sory

I have a column with countries in a file that was imported as an excel file. I dont have a specified column with the continents and im not intending to do this. It should run something like
If Cell(x,1) is Brazil then put "america"
If Cell(x,1) is Germany then put "europe"
and until the row in this column is empty

I have like ten countries on which i want to do this. Maybe theres a faster way to do this? But im trying to put this thing inside bigger macro

[TMS]

Please post a sample workbook with an accurate representation of your data and the code that you already have.

You could use VLOOKUP within the macro.

Regards, TMS

[mumsys]

That looks like this

[TMS]

OK, assuming the country/continent lookup table is on a sheet named "Continents", the code would look something like this:

Please Login or Register  to view this content.

See the attached updated sample workbook.

Regards, TMS

[TMS]

Thanks for the rep.