Hi,
I have a spreadsheet with 2 tabs.
What I now want to do is look up the master name in the split out sheet but I can't figure out a way to lookup against the multiline cells.
Example multiline sheet:
<tbody>
</tbody>
Example split out sheet:
<tbody>
</tbody>So now, I want to look up the master name (??) on value process against where it finds it in the multiline cell.
Can this be done?
Thanks
I have a spreadsheet with 2 tabs.
- 1 tab contains multiline values (column A) and it's master name (column B)
- The other tab has split out those multiline values into separate rows
What I now want to do is look up the master name in the split out sheet but I can't figure out a way to lookup against the multiline cells.
Example multiline sheet:
Process1 Process2 Process3 | Master1 |
Process4 Process5 | Master2 |
<tbody>
</tbody>
Example split out sheet:
Process1 | ?? |
Process2 | ?? |
Process3 | ?? |
Process4 | ?? |
Process5 | ?? |
<tbody>
</tbody>
Can this be done?
Thanks