SOLVED
Want to pick the data from another file ( like Vlookup)
Options
- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Mute
- Printer Friendly Page
Maheshp
8 - Asteroid
03-16-2023
05:44 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Hi Team,
I have a data in one file like below.
Name | Number | BOP | Amount | Debit | Credit | Total |
10X-Regel | 9783527509867 | BC.531460.01 | 0 | 0 | 0 | 0 |
10X-Regel Audio | 9783527509874 | BC.531460.02 | 0 | 0 | 0 | 0 |
1x1 der Kommunikation für Führungskräfte | 9783527507115 | BC.334707.01 | 0 | 0 | 0 | 0 |
200 and More NMR Experiments | 9783527310678 | BC.324560.01 | 0 | 0 | 0 | 0 |
2D Nanomaterials C | 9783527346776 | BC.530971.04 | 0 | 0 | 0 | 0 |
3D Bioprinting C | 9783527347964 | BC.539321.01 | 0 | 0 | 0 | 0 |
3D Images of Materials Structures | 9783527312030 | BC.332383.01 | -82.9 | 0 | 82.9 | 82.9 |
Another File Data:-
Number | Point |
9783527509867 | 400 |
9783527509874 | 300 |
9783527507115 | 500 |
9783527310678 | 300 |
But in another file i have " Numbers and Points only", with the help of option how can we get only POINT from that particular Number like below.
Name | Number | BOP | Amount | Debit | Credit | Total | Points |
10X-Regel | 9783527509867 | BC.531460.01 | 0 | 0 | 0 | 0 | 400 |
10X-Regel Audio | 9783527509874 | BC.531460.02 | 0 | 0 | 0 | 0 | 300 |
1x1 der Kommunikation für Führungskräfte | 9783527507115 | BC.334707.01 | 0 | 0 | 0 | 0 | 500 |
200 and More NMR Experiments | 9783527310678 | BC.324560.01 | 0 | 0 | 0 | 0 | 300 |
Regards,
Mahesh
Solved! Go to Solution.
Labels:
- Labels:
- Common Use Cases
3 REPLIES 3
RobertOdera
13 - Pulsar
03-16-2023
08:24 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Hi, @Maheshp
Please check out the options below.
Please mark it as an acceptable solution if it works for you - cheers!
ShankerV
17 - Castor
03-16-2023
09:19 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
RobertOdera
13 - Pulsar
03-18-2023
12:45 PM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
You're most welcome @Maheshp
