Please help me to sort this issue out. I am sharing a sample sheet in which i need to find out the latest data according to a specific name. in that sheet i have some details which are assigned to a code. the code of that product won't change but the shop id may change due to the purchase period. so when we enter a code it must go to the data page and select the latest row of that code. for eg : if the code is ABC111 and the data page have 10 ABC111 then it must select the 10th ABC111. the shop id may be differ from the rest 9. but the code must be same.. hope u got what i need.

here is the sheet. please help me to sort this out. thanks in advance - lizi

The formula will always get the last matching row from Data!A2:H with Data!F2:F Code matching to the Input!B2:B Code