View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
ppmorise ppmorise is offline
external usenet poster
 
Posts: 1
Default Assign a letter to a number and then retrive

I have huge data(numbers) that corresponds to specific text. So let's say 3
always refer to C4 and 5 always refer to C7 and I have 28 texts that refer to
specific number. Now when I obtain the data (3,5....) I need text that
corresponds to the number in another column. This is my first time using
excel and I am a chemistry major. So please help me with this.