Okay, now this video, we're going to do the V lookup multiple times. Basically, what we have is all of the states are listed here. The problem is we want to send out postcards to these vendors. And we can't do that with a mail merge, because we want to get the two character state abbreviation, the American abbreviation, okay. So we need a data set that it's going to reference, I happen to have it over here. So what I'm going to do is just do a quick copy of that.
And I'm going to paste it over here for just temporarily right there, okay. So, the first thing to do is insert a column where you'd like it to go just call it abbreviation And we are ready to rock and roll. So what it's going to do is going to look up Arkansas first, it's going to go down to find it. And then we're just going to want to reference the second position over. So this is going to be my table array. I look up each state and I'll be able to copy it down.
So it's super important that we absolute reference our table array structure here. To do that, it'll be dollar sign our dollar sign to colon dollar sign s, you know, all the way down to s 51. There. Okay, let's do it. So to begin, I'm going to select the Formulas tab, lookup and reference B lookup. Here we go.
My lookup value in this scenario would be Arkansas, e two. Okay. Then I'm going to tell it to look inside the table right for my next minute table. All right, I'm gonna do a little trick here, I'm gonna click on Alabama and use my Ctrl Shift arrow down on a PC Ctrl, Shift, arrow down, Control Shift, right. And then that gets me the data set. Now I'm going to hit f4 because it needs to be absolutely reference their column index number.
Again, think about it's going down, it's going to find state hit two over two. And our range lookup will be false. Just to prevent in case there's any Miss typing will get notified of that with an NA. So I'll hit OK. So far, like what I see I can copy it down. Also, if I wanted to just double click right there, that will copy it all the way down to the till it comes to the last row or a blank row.
Yeah, that is awesome. Awesome. Awesome. Awesome. Okay, so that is the V lookup, looking up multiple states.