N
NanGio
What formula would I use to look at data entered in one column for part of a
text string and return a select value if a set portion of that text string is
shown in a range of cells?
Example - All this data is on the same worksheet:
1) Column B, rows 12-123 are used to enter part numbers.
2) Table named "MaintTypes" in G141:H150 has column G = the first 6
characters of a part number and column H = the description of that maint type.
3) In cell C135, I want to return the equivalent description for a part
number starting with GE6300 (GE6300 and description are listed in "Maint
Types" table mentioned earlier).
text string and return a select value if a set portion of that text string is
shown in a range of cells?
Example - All this data is on the same worksheet:
1) Column B, rows 12-123 are used to enter part numbers.
2) Table named "MaintTypes" in G141:H150 has column G = the first 6
characters of a part number and column H = the description of that maint type.
3) In cell C135, I want to return the equivalent description for a part
number starting with GE6300 (GE6300 and description are listed in "Maint
Types" table mentioned earlier).