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 |
| Description | Material | Length | Width | Material Description | Material Description | |
| 1 | F-11-26 | LABEL - REGULER NSF PN.M-1-27-8 | Generic | ||||||
| 2 | F-11-27 | LABEL - REGULER NSF PN.M-1-27-8 | LABEL - REGULER NSF PN.M-1-27-8 | ||||||
3 Replies
- 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.I I understand you correctly, you should change the formula in column I from
=VLOOKUP(...)
to
=IF(J2="Generic",E2,VLOOKUP(...))
