OfficeUser
Well-known Member
- Joined
- Feb 4, 2010
- Messages
- 544
- Office Version
- 365
- 2016
- Platform
- Windows
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!!
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!!