Okay, I'm using vlookup between cells being merged from sheet 1 in order to
allow for the lookup value (sheet 2) to expand or contract based on the text
from the list returned. My formula is:
=Sheet1!B45&VLOOKUP(A35,Sheet2!A1:B38,2)&Sheet1!B48
Is it possible to bold the results of the lookup value within the merged cell?