From the course: Excel Power User Challenge

Unlock this course with a free trial

Join today to access over 24,700 courses taught by industry experts.

Retrieve from a partial string

Retrieve from a partial string - Microsoft Excel Tutorial

From the course: Excel Power User Challenge

Start my 1-month free trial Buy for my team

Retrieve from a partial string

“

- [Instructor] Right, let's see if we can make this one quick and easy. In column B, we have products. In column C, we want to retrieve the type for each product and that is over in column G in that table in a Type column header. So look at the data, see what's ahead of you, and notice that for that very first product, that is in the apparel type, right? Pause the video. Bring those types over. I'll do it and then we can get on out of here. (upbeat music) (tones ringing) All right, let's dive in. All right, cursor in the dataset. Format this as a table. That will help ensure that we can get moving and get on, 'cause I know that you got some exciting stuff waiting for you, and I'm not going to hold you up. I'm going to go XLOOKUP. Double click. Look up value. Ut-oh, there's the twist. All right, I want MID, open parentheses, because I see the pattern in these product codes. So I want MID. MID of what? Okay…

Contents