Forum Discussion
Excel autofill different texts
Please help me that if I want to add a code word in one cell, then how will a specific value related to code word will be entered in other cell.. Please help me
First, you have to inform Excel where it finds specific value related to code. By default Excel has no idea how your codes are linked with values and which ones. As variant that could be some table/range with values for each code. Could be other logic, depends on your data.
With that Excel could lookup entered code in such range and return related value. There are few functions in Excel which could do that.