Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations bkrike on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

VLOOKUP Differences between 200 and 2003

Status
Not open for further replies.
rgzimmer

rgzimmer

MIS
Aug 9, 2001
227
US
Does anyone know of a reason why a vlookup that returns a valid value when the spreadsheet is opened with Excel 2000 would return a value of N/A when opened with Excel 2003?
 
Sort by date Sort by votes
After further investigation, we have found that the user has a vbs script that runs against an access database to import the data into the spreadsheet. The database was written in Access 2000, which is the more likely source of the issue.
 
Upvote 0 Downvote
almost certainly, some data that was being impoted as numeric is now being imported as text or vice versa

Rgds, Geoff

Never test the depth of water with both feet

Help us to help you by reading FAQ222-2244 before you ask a question
 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

Cpreston
  • Locked
  • Question
whats wrong with Vlookup 2
2
Replies
20
Views
897
SkipVought
S
Cpreston
  • Locked
  • Question
vlookup issue 1
Replies
4
Views
384
combo
combo
Andrzejek
  • Locked
  • Question
Formula with & and a single quote 2
Replies
4
Views
962
OzFoxy
OzFoxy
wmbb
  • Locked
  • Question
Why does VLOOKUP work and MATCH function gives #NA 1
Replies
6
Views
599
wmbb
wmbb
R
  • Locked
  • Question
Issues with Outlook default account and performance
Replies
0
Views
563
radleymartinez
R

Part and Inventory Search

Sponsor

Back
Top