title: How to get the column names in excel
body: <p>I am currently working on converting an excel table with >100 calculated columns into a DAX table with similar calculated columns.</p>
  
  <p>Excel formula refers to the columns by their column coordinates, e.g. sum = A2+B2</p>
  
  <p>whereas DAX refers the column name in the formula, e.g. sum = Principal +Interest</p>
  
  <p>Now, when I am trying to convert excel version of sum=A2+B2, is there any clever way for me to find out A=Principal and B= Interest in the spreadsheet.</p>
  
  <p>I am talking about a table which has >50 non calculated columns and >100 calculated columns to be converted to comparable DAX model. Every time I look into a formula for the calculated columns in excel,
  e.g.</p>
  
  <p>Interest = =IF(AND(AR7="Pending",OR(V7="Completed",V7="Approved", LEFT(V7,4)="OPEN")),IF(U7*1>0,U7*1,N7)/VLOOKUP(F7,Tax!A:B,2,0),0)</p>
  
  <p>I need to go back and forth in the table to find out what are the corresponding column for each coordinate in this.</p>
  
  <p>Is there any clever way for me to find out what column names correspond to which column coordinate in the above formula, for example AR=Status, V=Application, U=Amount.....</p>
  
  <p>Thank you in advance.</p>