Vlookup not functional for external data

[crkovacs]

Hello

I'm having the following issue and I really hope you may help me since I'm far to be an expert in excel ...
I do have an excel file taking data from an external source via odbc connection. Based on data retrieved when refreshing the file, I would like to use 2 columns containing VLOOKUP functions that refer to the first column in the worksheet (external data).
When having first time vlookup done it is working fine,
but when refreshing the data it is always giving me #N/A results although there are info that match the criteria.

Would you pls help me to sort this out?

Thanks
Cris

 

[GlennUK]

What value are you looking for? Does the formula change at all during refresh?

 

[Andrew Poulsom]

Welcome to the Board.

Can you post your formula that returns #N/A?