All Questions
3
questions
1
vote
1
answer
363
views
Lookup multiple values in a different table given a cell containing multiple delimited values
I have two tables, which look like this:
I would like Excel to use the value in ID company associated in table 2 (green), look for it in table 1 (orange) and return the value from Company name, or ...
- 25
1
vote
1
answer
172
views
Allow a cell containing multiple delimited lookup source values to also contain non-lookup values
Lookup multiple values in a different table given a cell containing multiple delimited values
Please open the link to see the previously answered question.
Given that context, is there a formula ...
- 25
0
votes
2
answers
3k
views
Map/Copy values from one sheet to another in excel if they match on column header
This post gets me very very close to where I need to be
How can I copy a column from one sheet to another sheet based on title in Excel?
However if I add an =if(isblank(Sheet1!A2),"",... to the ...
- 113