What I'm trying to do is simply have a formula insert the contents of another cell into a formula to reference a cell in another spreadsheet.
Using the above example, the first column in the spreadsheet is a vehicle number. The second column is the formula which will reference another cell with a separate spreadsheet. What I'm trying to do is have the formula reference the 1st column and grab that vehicle number instead of me having to had type it into the formula every time as I've done here.
I hope my explanation is clear. Please let me know.