title: Excel How to input Cell with column letter and row number (dynamic) No VBA
body: <p>let's say in Cell A1 I have the value "A". In Cell B1 I have the value "2". Is there a way to make a reference to the Cell A2 with the value of these two cells? </p>
  
  <p>I was thinking about something along the way of =A1&amp;B1 , but it does not work.</p>
  
  <p>The reason I want this is I want to generate a dynamic row number e.g. with the MATCH() function and use this row number (e.g. A&amp;MATCH() ). Is there a way to do this?</p>
  
  <p>I know how to do it with VBA, but is there a way to do it without VBA?</p>
  
  <p>Thanks to all in advance.</p>