title: Vlookup using awk command
body: <p>I have two files in my linux server.</p>
  
  <p>File 1</p>
  
  <pre><code>9190784
  9197256
  9170546
  9184139
  9196854
  </code></pre>
  
  <p>File 2</p>
  
  <pre><code>S NO.,Column1,Column2,Column3
  72070,9196854,TGM,AP
  72071,9172071,BGM,MP
  72072,9184139,AGM,KN
  72073,9172073,TGM,AP
  </code></pre>
  
  <p>I want to write a script or a single line command in bash using awk command, so as whatever the element in File -1 should match the same with column 1 in File -2 and print Column 1, Column2 and Column3. Also if any entry is not found it should print entry from file 1 and print NA in Column 2 and Column 3</p>
  
  <p>Output : it should redirect the output to a new file as below.
  new_file</p>
  
  <pre><code>9190784,TGM,AP
  9197256,NA,NA
  9170546,NA,NA
  9184139,AGM,KN
  9196854,TGM,AP
  </code></pre>
  
  <p>I hope the query is understandable. Anyone please help me on the same.</p>