Pairing up names based on their assigned number

[hexr]

secretvalentine.jpg

So my goal is to come up with a formula to pair up the 26th person with the first person, the 2nd with the 25th, the 3rd with the 24th, etc. I also must do this by putting the full name of their match into the "Secret Valentine" column. I have absolutely no idea how I can do this, any suggestions? Would the INDIRECT function be in any way useful here?

[djapigo]

Hi hexr,

The way you have it set, this should be pretty easy...

Try this... =MATCH($B$3:$B$28,A3,0)

[hexr]

I tried it and it came up as #NA. From reading about the MATCH function it looks like it could work, but I can't figure out how.

[djapigo]

Is Col A actual numbers? If so, then the formula should work... if not, try this instead...
=MATCH($B$3:$B$28,VALUE(A3),0)

[djapigo]

Oops, my mistake...

It should be INDEX, not MATCH...

Try this... =INDEX($B$3:$B$28,A3)

[hexr]

It worked, thank you!