# (Bloomberg) BDP Formula question [closed]

Good Morning,

I am using the below formula and need some help, how do I change the below strike price (400) to pull from a separate cell (T2) I have on the spreadsheet?

=BDP("odcn8c_*400*_comdty","vega")*I68*50


Just concatenate the string (and replace the _ with spaces to form a valid ticker):

=BDP("odcn8c " & T2 & " Comdty", "vega") * I68 * 50

• After trying this I am getting the following, "#N/A Invalid" – Dominic Jun 7 '18 at 14:18
• with 400 in cell T2 it works for me, unless you have something incorrect in cell I68. – assylias Jun 7 '18 at 14:28
• the value in I68 i don't think would be able to cause an #N/A Invalid result, as that's what bbg returns. – will Jun 8 '18 at 12:57
• Make sure you have 400 as a string, not as a number. Use text conversion if necessary, example: =TEXT(I68) – Alex C Jun 8 '18 at 13:26
• @Dominic So =BDP("odcn8c 200 Comdty", "vega") works, but =BDP("odcn8c " & T2 & " Comdty", "vega") with 200 in T2 doesn't? – assylias Jun 8 '18 at 15:03