View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
sompura sompura is offline
external usenet poster
 
Posts: 7
Default how to use functions.

I have 3 columns in Col. A numbers between 1 to 10 in nearly 400 raws, in
Col.B Same numbers i.e. 1 to 10 which represents code of country shown in
Col.C and in Col.C names of Country like America, Brazil, China, India,
Pakistan, Barma etc. I want to replace Col. A's numbers with Country's name
which will be appropriate function for replacement of numbers.

I will be thankful for your valuable suggession.