Vlookup using data connection

[moofish87]

Hi,

Newb to excell.

I'm having an issue when I try and use a Vlookup on a data connection table from another workbook.
I keep getting a N/A error as if it cant find the data to return.

Is this possible or do I need another formulae?

Thanks for any help

 

[RasGhul]

You may need to have a tab with the data connection table, then point the vlookup at this.