title: VLOOKUP on Calculated Cell Failing
body: <p>I am new to using VLOOKUPS - I am having an issue where the value its pointing at (Cell E2) is a calculated cell in itself, the VLOOKUP only seems to work if I Hardcode a value into the cell.</p>
  
  <p>Are there any ways I can get around this - I am surprised I couldn't find this on the Internet so far given it must be quite a common problem</p>
  
  <p>VLOOKUP Code: =VLOOKUP(E2,'Colour Code'!A$2:B$11, 2, FALSE)</p>
  
  <p>Formula in Cell E2: =LEFT(C2,1)</p>
  
  <p>In this case the value thats calculated in E2 is "3" but the VLookup only works if I literally type "3" into the Cell, I get an #N/A error otherwise</p>