I'm trying to create a vlookup that references different documents depending on other items in the row. The document name can be created by combining these other items in the row, so I have made a column which contains the document name, as well as the array within that document that I'd like to look at. I need to use the contents of this cell as the second argument in my vlookup.

The function is currently turning up an error, and I believe that is something to do with the formatting of the second argument. My vlookup has the form =vlookup(K4, "'Location&C4&F4&Name'!$G:$T", 14,0), where C4 and F4 are the parts of the document name being pulled from my spreadsheet. Does anyone know why this is returning an error?


Thanks!