Excel 2007, Columns, URLS, and Hyperlinks - will this be possible?

[OMGohNOES]

Ok so is this possible??

I have a column of a list YouTube video names. Let's say Column A.

Column B is a list of corresponding URLs to that YouTube video.

Is it possible to create a Column C that exactly lists Column A but each cell is hyperlinked to the corresponding URLS in Column B?

I've looked at the Hyperlink function and I can't point them to columns. Kinda dumb.

This list has dozens and I'm not in the right mind to link each one, one by one

[mubashir aziz]

Its better to attach a smple file but If I am not wrong then below formula will work fine.


A1 : Exce B1: http://www.excelforum.com C1=HYPERLINK(B1,A1)