VLOOKUP based on PART of another cell's text
I want to automatically fill in column B (from a seperate list) based on part
of the cell in column A. For instance, A312 = "MW3-11315AH" Now, I would like to fill in B312 with "SHANK", based on the "MW3" at the beginning of the text string in A312. Also, A313 = "B2-P-N49B-A0014" I would like to fill in B313 with "ARM ASSY", based on the "A0014" at the end of the text string in A313. However, the numerical portion of "A0014" (A####) will change. I was hoping to create a list on another worksheet, and use VLOOKUP, but I am unsure as to the implementation of wild-card or partial-content lookups. Any help is GREATLY appreciated! |
All times are GMT +1. The time now is 02:48 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com