Use cell value as reference in a hyperlink

Hi, I have a small issue with hyperlink

https://.../Search/QuickLink.aspx?n=A123-BCD-E-FGH-I456_JK789_0-12345&t=3&d=Main%5ceBProd&sc=Global&r=A12&cno=E_SOURCE&m=l

A123-BCD-E-FGH-I456_JK789_0-12345 - needs to be B2 cell value
A12 - needs to be C2 cell value

when I drag the function down, it has to pick B and C valued according to row. I am missing a mistake somewhere. Please help.

I last tried this function and it didn't work.
=IF($B2<>"",HYPERLINK("https://.../Search/QuickLink.aspx?n="$B2"&t=3&d=Main%5ceBProd&sc=Global&r="$C2"&cno=E_SOURCE&m=l","Open"),"")

You need to join the strings together with the ampersand:

=IF($B2<>"",HYPERLINK("https://.../Search/QuickLink.aspx?n="&$B2&"&t=3&d=Main%5ceBProd&sc=Global&r="&$C2&"&cno=E_SOURCE&m=l","Open"),"")

Hope this helps.

Pete

Great! It worked! Thank You Pete!!!

You're welcome - thanks for feeding back.

Pete