Search results

O Oh yeah, I am so sorry I didn't notice it. Thanks Sir...

Dear arnelgp, When a set of large data is added some result is missing.. plz see the attached file.. thanks..

Ok, It is Solved, Thanks a lot...

Dear Arnelgp, There is a little inaccuracy in the result when I modified the index & value data.. Please have a look at the attached file. Thanks

Dear Arnelgp, I thank you once again for your brilliant efforts. My query is Solved Thanks...

can anyone else provide me a vba code..?

Hi @ arnelgp, i have a query subject "excel vba vlookup multiple values" could you please reply a solution... thanks,

Dear Pbaldy, It doesn't matter if we shift "index" to the left of "value". I just need the result as mentioned. Could you please set the above attached file to get the desired "result" (through a vba code) Thanks.

Hi, Pbaldy, I have reattached my xls file.

Hi, I am looking for a simple vba for excel, to match a vlookup values mentioned in column 'E' and display the result in column 'F' Given Index in Column 'B' and value in Column 'A' Note : The attached file is a sample, but the actual data may be upto 100 rows...or more

Excellent Sir, it is improved. Your are a Genius.. Thanks a lot.

Dear arnelgp, I tried for a bigger Dataset, it took 6 minutes to display the result(very slow) for upto 80 Rows data. But beyond 80 rows, it shows its busy.... Please provide a solution see attached file...

OK Sir, I will ...thanks..

Dear arnelgp, Yes, its working good... My query is Resolved...

Dear arnelgp, When I click the blue button it is showing error

Dear arnelgp, I am still getting Runtime error 438 with "macro 1" *** I then Used Macro "do_path", it is working good*** Any new entries Sources, I am sorting manually... I thank you for your excellent efforts...

Dear arnelgp, The above attached file is showing Runtime error 438.. However in the earlier file, I sorted all A,B,C... manually by using sort Tool. Almost all paths traced except one path(see attached file)... Please advice..

Dear arnelgp, Further, more path is missing :

Dear arnelgp, Further, one path is missing :

Dear arnelgp, ***Well done, I have cross checked it. Everything is working fine*** I will be having some more than 100 rows, hence I need to assign the different combination of alphabets & numerical figures (example "CUU-01" instead of using single alphabets "A,B,C,D...") These combination...