title: Excel Combining of VLOOKUP with another SUBSTITUTE, REPLACE, or IF THEN
body: <p><a href="https://i.stack.imgur.com/cnCDZ.jpg" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/cnCDZ.jpg" alt="enter image description here"></a></p>
  
  <p>I am looking to be able to type in an ITEM CODE from column J into column F and have that replaced with its corresponding FULL DESCRIPTION in column K. From there it will lookup its corresponding cost and populate into column H.</p>
  
  <p>I have gotten as far as to get the cost matched up with 
  =VLOOKUP(F3,$K$3:$L$50,2,FALSE)
  but I can't seem to get column F to SUBSTITUTE or REPLACE. Any help would be appreciated.</p>