yogi_Pull Latest Data From Specified Fields For Entities In A2:A13

Google Spreadsheet   Post  #2529

Yogi Anand, D.Eng, P.E.      ANAND Enterprises LLC -- Rochester Hills MI     Oct-27-2018

question by: sanjeev kumar sharma
https://productforums.google.com/forum/?utm_medium=email&utm_source=best_answer_notification_button#!topic/docs/3Lq0kAMoIS8;context-place=forum/docs

automatically pick up details

Hello to all experts. I am again here with a new query. The query is that in warp status sheet, in column a, 3 to 16 are machine numbers. 
And in coumns g:k are their details. I want that in column a each machine number should pick up the last detail of automatically. 

For example-- regarding cell a2 (machine no. 3) the last detail is i21:k21 (yellow coloured area) (cotton 1150 10/27/2018). 
And so on for every machine nhttps://docs.google.com/spreadsheets/d/154uZpHNsenoDKe8aYXz4nRqolE_jRsBUUMSF5v3ZhBc/edit#gid=1999752622umber.