The formula in DN2 is: =LEFT($B2,7)&"-"&$C2)
The formula in BV2 is: =IF($B2="","",VLOOKUP($DN2,Specs!$A$2:$K$500,9,FALSE))
What I am trying to do is combine them so that I can get rid of column DN altogether. Essentially trying to make a formula that operates, similar to this attempt...