مطالب مرتبط با «excel vlookup with multiple values» در Recent Questions | نویسنده: استخدام کار
Excel: VLOOKUP with cell containing multiple references
I have a table which contains multiple references per cell separated by a blank space. In an other table that contains one line per reference, I want to use VLOOKUP to retrieve the name of the component which is linked to each reference. Here is an example of my first table: And here is the result I'm trying to achieve: Use VLOOKUP of the reference to get the component name in the first table. I caot get it to work as the number of references associated to a component is not constant. Let's block ads! بخوانید...
ادامه مطلب
