Extract data from different columns in an excel sheet and merge them as a string.

Hey all,

I am trying to extract the country specific data in from the excel sheet and merge the column names Country, Population as a string which will give an output as: "If country= XXX then population = YYY"

Can anybody help me as i have no idea how to do this.

hi
a couple of questions
are you trying to return a string for every country, or look up a particular country in your sheet and return data from that row?
also, what do you mean by "population" - none of the data in your sheet is labeled "population"?

Hi
am trying to return a string for every country. and column E has population data

ok, but there are no data in column E in the spreadheet you uploaded

if the country name is in column A and the population data in column E, this formula dshould return the string you want:

Please Login or Register  to view this content.

Thanks, to both of u it worked