Hi, can anyone help? I currently have two quite large tables. I want to create a third table which:
- looks at a specific cell in table 1
- finds a cell that align with it in table 2
- creates a new version of table 1 with the information found in table 2
that's probably confusing without seeing it, the extract attached tries to show:
Cell C3 =-Role B requires an Awareness level of Benefits
Cell B10 = text that is relevant to "awareness level in benefits"
Cell L9 = needs to show the text from B10
If anybody has any ideas, or can just tell me whether or not this is possible that would be great !
Thanks in advance!
Bookmarks