Add values from one sheet to another based on field IDs

%3CLINGO-SUB%20id%3D%22lingo-sub-1540453%22%20slang%3D%22en-US%22%3EAdd%20values%20from%20one%20sheet%20to%20another%20based%20on%20field%20IDs%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1540453%22%20slang%3D%22en-US%22%3E%3CP%3EHello%2C%3C%2FP%3E%3CP%3EI%20have%20a%20sheet%20with%20two%20tabs%20with%20data%20for%20an%20import%20to%20a%20content%20management%20system%20(website).%20One%20tab%20consist%20of%20post%20content%20data%2C%20where%20there%20are%20post%20titles%2C%20post%20content%20and%20image%20IDs%20(a%20set%20of%20numbers%20identifying%20images%20assigned%20to%20this%20post).%20My%20second%20tab%20is%20the%20image%20reference%20-%20there%20are%20only%20two%20columns%3A%20one%20with%20the%20image_ID%20number%20and%20the%20other%20with%20the%20image%20URL%20address.%26nbsp%3B%3C%2FP%3E%3CP%3ENow%20I%20want%20a%20third%20result%20tab%20to%20show%20what's%20in%20my%20first%20post%20content%20tab%2C%20but%20in%20an%20extra%20column%20to%20show%20the%20image%20URL%20addresses%20that%20result%20from%20the%20image_ID%20numbers%20in%20the%20other%20column.%3C%2FP%3E%3CP%3EI%20attach%20an%20example%20sheet%20with%20the%20result%20expected%20tab.%20Any%20ideas%20how%20to%20do%20this%3F%20Thx!%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1540453%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EFormulas%20and%20Functions%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1540663%22%20slang%3D%22de-DE%22%3ESubject%3A%20Add%20values%20from%20one%20sheet%20to%20another%20based%20on%20field%20IDs%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1540663%22%20slang%3D%22de-DE%22%3EMaybe%20with%20the%20function%20%3D%20VLOOKUP%20()%20%3CBR%20%2F%3E%20%3CBR%20%2F%3E%20%3CA%20href%3D%22https%3A%2F%2Fsupport.microsoft.com%2Fen-us%2Foffice%2Fvlookup-function-0bbc8083-26fe-4963-8ab8-93a18ad188a1%22%20target%3D%22_blank%22%20rel%3D%22noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%22%3Ehttps%3A%2F%2Fsupport.microsoft.com%2Fen-us%2Foffice%2Fvlookup-function-0bbc8083-26fe-4963-8ab8-93a18ad188a1%3C%2FA%3E%20%3CBR%20%2F%3E%20%3CBR%20%2F%3E%20Nikolino%20%3CBR%20%2F%3E%20I%20know%20I%20don't%20know%20anything%20(Socrates)%3CBR%20%2F%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1549504%22%20slang%3D%22en-US%22%3EBetreff%3A%20Add%20values%20from%20one%20sheet%20to%20another%20based%20on%20field%20IDs%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1549504%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F722750%22%20target%3D%22_blank%22%3E%40Nikolino%3C%2FA%3E%26nbsp%3Byeah%2C%20VLOOKUP%20was%20on%20my%20radar%2C%20but%20this%20works%20with%20single%20data%20per%20cell%2C%20while%20I%20have%20multiple%20data%20in%20one%20cell%20(divided%20with%20a%20semicolon).%20That's%20why%20I%20was%20wondering%20whether%20there's%20a%20different%20way%20to%20do%20this...%3F%3C%2FP%3E%3C%2FLINGO-BODY%3E
Highlighted
New Contributor

Hello,

I have a sheet with two tabs with data for an import to a content management system (website). One tab consist of post content data, where there are post titles, post content and image IDs (a set of numbers identifying images assigned to this post). My second tab is the image reference - there are only two columns: one with the image_ID number and the other with the image URL address. 

Now I want a third result tab to show what's in my first post content tab, but in an extra column to show the image URL addresses that result from the image_ID numbers in the other column.

I attach an example sheet with the result expected tab. Any ideas how to do this? Thx!

2 Replies
Highlighted
Highlighted

@Nikolino yeah, VLOOKUP was on my radar, but this works with single data per cell, while I have multiple data in one cell (divided with a semicolon). That's why I was wondering whether there's a different way to do this...?