VLOOKUP external data

[sknight22]

Hello,

I am trying to make a worksheet vlookup from another data source using the below.

=VLOOKUP(C10,'C:\Users\scusk1\Desktop\Stephen\Archived Workbooks\[Driver Database Live.xlsx]iForm Data'!$1:$1048576,11,FALSE)

Can anyone spot an error as it is returning NA

Thanks
Stephen

 

[louisH]

Hi,

VLOOKUP return NA when it doesn't find the value to search.
It probably just didn't find your C10 value in the first culumn of your external sheet.
Also $1:$1048576 looks a bit vague for a searching area. Do you really need to look in the whole sheet ?

 

[sknight22]

Thank you. I have just changed the column in my eternal sheet that I am searching for by converting to number and it is now working.

Than you for your reply