Hi,
I need a help on the following.
I have 2 excels, for few amounts in one excel I need to find data from another excel ( all line items) based on the amount. Since my excel runs into 7 to 8 lacs line items, using Vlookup not works as lot of duplicates. is there any formula i can get ?
Thx for your great help.
Aditya
I need a help on the following.
I have 2 excels, for few amounts in one excel I need to find data from another excel ( all line items) based on the amount. Since my excel runs into 7 to 8 lacs line items, using Vlookup not works as lot of duplicates. is there any formula i can get ?
Thx for your great help.
Aditya