Vlookup (With concatenate) to workbook

[Dibbley247]

I have a Vlookup working to another workbook.

Please Login or Register  to view this content.

(all drive letters are ifferent depening on computer, so server numbers are used)

BUT the vlookup part I want as a concatenate

Please Login or Register  to view this content.

But i'm always getting an error when trying to combine them?
this is what i've done????

Please Login or Register  to view this content.

Where is the wrong comma/bracket?


Thanks

[mcmahobt]

You still have your original lookup value inside the parenthesis:

Please Login or Register  to view this content.

Try:

Please Login or Register  to view this content.