Combining two formulas into one

[OfficeUser]

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:

=IF($B2="","",VLOOKUP(LEFT($B2,7)&"-"&$C2),Specs!$A$2:$K$500,9,FALSE)

Can anyone point me in the right direction? Thanks!!

 

[dreid1011]

It looks like you closed your VLOOKUP too soon.

Perhaps this:


=IF($B2="","",VLOOKUP(LEFT($B2,7)&"-"&$C2,Specs!$A$2:$K$500,9,FALSE))

 

[OfficeUser]

I sure did, thanks!!

 

[dreid1011]

You're welcome.