Christopher12
New Member
- Joined
- Oct 14, 2009
- Messages
- 6
Hi all, this is probably easy for you but I'm having problem with VLOOKUP and Visual Fox Pro database.
So here it is, the formula is correct and worked fine, until I specified the "Table array" of Fox Pro database, which I used MS Query to get it as an external database into Sheet 2, I also have to run VFPODBC.msi before I can link to it.
If I use this: =VLOOKUP(E5,Sheet2!A1:S8958,3,FALSE) then I got "#N/A" return. 32321 is in E5.
If I use this: =VLOOKUP("32321",Sheet2!A1:<wbr>S8958,3,FALSE) then it worked fine, looking up "32321" in the Fox Pro database and return value 3 columns over. But this is a pain since there are many more rows to work with.
Please help
Thanks
Christopher
So here it is, the formula is correct and worked fine, until I specified the "Table array" of Fox Pro database, which I used MS Query to get it as an external database into Sheet 2, I also have to run VFPODBC.msi before I can link to it.
If I use this: =VLOOKUP(E5,Sheet2!A1:S8958,3,FALSE) then I got "#N/A" return. 32321 is in E5.
If I use this: =VLOOKUP("32321",Sheet2!A1:<wbr>S8958,3,FALSE) then it worked fine, looking up "32321" in the Fox Pro database and return value 3 columns over. But this is a pain since there are many more rows to work with.
Please help
Thanks
Christopher
