Autofill Row based on cell value in that row

[zayd_88]

Hello,

I'm trying to get my excel sheet to auto-fill as row based on a cell value in that row. For Example If i type a company name in column M and that value exists in a previous row, I would like excel to auto fill the rest of the cell values with the matched values that were previously found. Can Anyone help me?
Thanks

 

[zayd_88]

Hey guys,

I managed to do this with V-Lookup as well as INDEX and MATCH