Forum Discussion
Excel, Formulas and Functions
Hi,
I have a little problem with excel formula, can you help me solve this problem?
the problem is in "column I" has been filled a formula "Vlookup" which is integrated with
the key sentence in "column K", so how do I fill in "column I", with the keyword
"Generic" for results that are exactly the same as "column E" but do not eliminate
the formula in "column I"
thanks a lot
regards
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.
3 Replies
Hello,
i understand you want to find search value of cell K11 in range $M$26:$N$150.
VLOOKUP searches for value of cell K11 in range M26:M150. If value is found, the corresponding entry of range N26:N150 is returned.
The returned value has to be compared to the value in cell E11. If the returned value is identical to the value in E11 vlookup has to return "Generic" in cell I11. If values are not identical, the returned value from range N26:N150 has to be displayed in I11.
This formula helps you with this, enter formula in I11 and copy down to I20:
=IF(VLOOKUP(K11,$M$26:$N$150,2,FALSE)=E11,"Generic",VLOOKUP(K11,$M$26:$N$150,2,FALSE))
The values in E11:E20 were missing in return range N26:N150 and there was no valid search value in cells K11, K13, K14 , K16 and K18. Therefore i choose 1,2,3,4 and 5 as search values and added the necessary information in range $M$26:$N$150.
Please see the attached file to demonstrate the solution.
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.
