| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
VLOOKUP IS NOT Enough
I have tried applying many formulas suggested which are posted but in vain, I
have got partial results but not complete. Let me explain my proble. I am working on two different files let us say Name1 and Name2 Name 1 Data: Invoice Number INV AMT ARSINHUBHU107/2527 23585 ARSINHUBHU107/2527 36739 ARSINHUBHU107/2528 7199 ARSINHUBHU107/2529 11792 ARSINHUBHU107/2530 11792 ARSINHUBHU107/2530 12246 ARSINHUBHU107/2531 24492 ARSINHUBHU107/2532 11792 ARSINHUBHU107/2539 12246 ARSINHUBHU107/2540 8398 ARSINHUBHU107/2540 8789 ARSINHUBHU107/2541 11792 ARSINHUBHU107/2544 12246 ARSINHUBHU107/2544 7199 ARSINHUBHU107/2545 12246 ARSINHUBHU107/2545 7199 ARSINHUBHU107/2550 18215 ARSINHUBHU107/2550 12246 ARSINHUBHU107/2550 7199 ARSINHUBHU107/2551 11792 ARSINHUBHU107/2605 44720 Name 2 Data Invoice Number ReceiptNo ARSINHUBHU107/2527 ARMCNHUBHU107/520 ARSINHUBHU107/2527 RAHUB20070700061-00001 ARSINHUBHU107/2528 ARMCNHUBHU107/541 ARSINHUBHU107/2528 RAHUB20070700061-00001 ARSINHUBHU107/2529 RAHUB20070700061-00001 ARSINHUBHU107/2530 RAHUB20070700061-00001 ARSINHUBHU107/2531 RAHUB20070700061-00001 ARSINHUBHU107/2532 RAHUB20070700061-00001 ARSINHUBHU107/2539 RAHUB20070700061-00001 ARSINHUBHU107/2540 RAHUB20070700061-00001 ARSINHUBHU107/2541 RAHUB20070700061-00001 ARSINHUBHU107/2544 RAHUB20070700061-00001 ARSINHUBHU107/2545 RAHUB20070700061-00001 ARSINHUBHU107/2550 RAHUB20070700061-00001 ARSINHUBHU107/2551 RAHUB20070700061-00001 ARSINHUBHU107/2551 RAHUB20070700061-00002 ARSINHUBHU107/2604 RAHUB20070700001-00001 ARSINHUBHU107/2605 RAHUB20070700001-00001 ARSINHUBHU107/2606 RAHUB20070700001-00001 ARSINHUBHU107/2607 RAHUB20070700001-00001 ARSINHUBHU107/2608 RAHUB20070700001-00001 ARSINHUBHU107/2612 RAHUB20070700061-00002 ARSINHUBHU107/2617 RAHUB20070700001-00001 ARSINHUBHU107/2619 RAHUB20070700126-00002 ARSINHUBHU107/2620 RAHUB20070700126-00002 ARSINHUBHU107/2620 RAHUB20070700133-00001 ARSINHUBHU107/2634 RAHUB20070700133-00001 ARSINHUBHU107/2638 RAHUB20070700026-00001 ARSINHUBHU107/2639 RAHUB20070700133-00001 ARSINHUBHU107/2664 RAHUB20070700090-00001 ARSINHUBHU107/2682 RAHUB20070700001-00001 This is a big file and is not always sorted The result which I wish to get is the following. Invoice Number INV AMT ReceiptNo ARSINHUBHU107/2527 23585 ARMCNHUBHU107/520 ARSINHUBHU107/2527 36739 RAHUB20070700061-00001 ARSINHUBHU107/2528 7199 ARMCNHUBHU107/541 ARSINHUBHU107/2528 7199 RAHUB20070700061-00001 Is it possible? I hope so ( It is not that easy as it looks) This is a real challenge, all the Excel experts out there, kindly help. Thanks in advance Cheers Sharmila€¦€¦ |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Vlookup in vlookup - taking the result as array name | Excel Worksheet Functions | |||
| Combine VLOOKUP and IF function so #NA isn't returned as a value from VLOOKUP | Excel Discussion (Misc queries) | |||
| Vlookup -=VLOOKUP(F9,LookUp1!$A$2:$B$1504,2,FALSE) | New Users to Excel | |||
| IF(AND(val1=VLOOKUP( );val2>=VLOOKUP( );val2<=VLOOKUP( );VLOOKUP( | Excel Worksheet Functions | |||
| Vlookup info being used without vlookup table attached? | Excel Worksheet Functions | |||
Threaded Mode
