I need some ideas for the below use case.
- There is two different Excel File , Excel 1 is a master File and Excel 2 is a child file
- I need to do Vlookup in Excel2 with Excel 1 and wherever data is not available i need to remove entire data set from excel 2 to diff Excel File( may be Excel3 )
3.Problem here is its a big data - Master file is carrying 15000 data and child file is carrying 9000 records - if i use index to look up it may take lot of time, its a loop likewise it has to do around 10 times
Can anyone suggest some smart way to do this ?