Match two similar columns

[monke0044]

Hello all,

OK, so I have one column that has numbers 1-31, and then a 2nd column that begins with numbers and has other information as well, but not all numbers are the same. Not sure that made any sense...but basically I'd like to know if there is a way to do something like the following:

Right now it looks like this:

A | B
1 | 2 Smith
2 | 3 Doe
3 | 4 Bob
4 | 6 Jane
5 | *Blank*
6 | *Blank*

But I'd like to have it look like this:

A | B
1 | *Blank*
2 | 2 Smith
3 | 3 Doe
4 | 4 Bob
5 | *Blank*
6 | 6 Jane

Much appreciated

[DBY]

Hello
If for example your first set of data is in the range A1:B6 and you want to return your re-arranged data in E1:F6 for example, then try the following formula copied down column F:

=IFERROR(INDEX($B$1:$B$6,MATCH(E1&"*",$B$1:$B$6,0),1),"")

I'm assuming you want to return blank cells "" for no match and not literally "*Blank*".