Forum Discussion
Excel, Formulas and Functions
Hi there,
To be honest, I tried to understand your query.
As far as I understand, you want to add word Generic to each row of I Column where we see Vlookup function results.
From other point of view, there is data validation on I column.
So, I added word of Generic to N column using &.
The solution is attached to this message.
P.S. Of course, there are other ways to solve this problem, however, If you found my solution satisfactory, please highlight it.
Thanks in advance.
Hi there,
To be honest, I tried to understand your query.
As far as I understand, you want to add word Generic to each row of I Column where we see Vlookup function results.
From other point of view, there is data validation on I column.
So, I added word of Generic to N column using &.
The solution is attached to this message.
P.S. Of course, there are other ways to solve this problem, however, If you found my solution satisfactory, please highlight it.
Thanks in advance.
