View Single Post
  #2   Report Post  
 
Posts: n/a
Default

If you assume that the "DataTable" above was in range A1:E5, and that
you placed your "NewTable" in range A10:E14, you could enter this
formula into cell B11:

=IF(ISERROR(INDEX($A$1:$E$5,MATCH($A11,$A$1:$A$5,0 ),MATCH(B$10,$A$1:$E$1,0))),"NoMatch",INDEX($A$1:$ E$5,MATCH($A11,$A$1:$A$5,0),MATCH(B$10,$A$1:$E$1,0 )))

And then drag it to fill the cells from B11:E14.