Excel #37 - Advanced Two-Way Lookup with Index Match in Tamil

#TwoWay# #Lookup# # Index&Match# Advanced Two-Way Lookup with Index Match in Tamil I am a huge fan of INDEX MATCH combo and I have made it pretty clear with following points Index + Match Data Validation with Drop-Down List OFFSET Dynamic Range IFERROR Fruits KG =OFFSET(Data!$A$2,,,COUNTA(Data!$A$2:$A$1048576)) Fruits_Name = =OFFSET(Data!$B$1,,,COUNTA(Data!$B$1),COUNTA(Data!$B$1:$XFD$1)) Please subscribe, hit like and share your friends.