Forum Discussion
match the description with value entry
if the value "J2" = "Generic" then the value "I2" must be equal to "E2" Item No. Quantity Component Description Material Length Width Material Description Material ...
thanks a lot for help me,
one more time sorry sir, in "column I" has been filled a formula "Vlookup" which is integrated with the key sentence in "column j", 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"
thank's
Rgrd.
one more time sorry sir, in "column I" has been filled a formula "Vlookup" which is integrated with the key sentence in "column j", 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"
thank's
Rgrd.
I I understand you correctly, you should change the formula in column I from
=VLOOKUP(...)
to
=IF(J2="Generic",E2,VLOOKUP(...))