All Questions
2
questions
1
vote
1
answer
386
views
Excel - Concatenating cells returned through looking up against duplicate values
I have a unique problem that I have been unable to solve and hoping to get insights from the experts here. I have the below table:
Sprint ID# Description
1 ABC
1 XYZ
2 ...
0
votes
1
answer
3k
views
how to concatenate the output of vlookups in one step
I'm trying to run two vlookup operations and concatenate the results in one formula as such:
=CONCATENATE(
VLOOKUP($A$6,'TRP'!$A$7:$D$655,2,FALSE),
"/",
VLOOKUP($A$6,'HCP'!A5:B655,2,FALSE)
)
The ...