Database question

help

[malcolmcroucher]

what im doing :

Im preparing my data in excel before i import it into mysql . I have some data integrity issues i was sorting out.

My problem is not with mysql but with excel.

Im doing a vlookup to place country-id's next to each city. I have 507 cities so its quite time consuming to go through each one .
my vlookup looks like this

=VLOOKUP($D1,countries!A$1:D$500,2,TRUE)

but it keeps returning data a line below where it should be e.g :

America123
America123
America123
Andorra123
Angola9
Antigua and Barbuda98
Argentina98
Argentina98
Armenia126
Aruba139

Andora should not be 123 it should be 9 (which has passed to angola )

so what its doing is adding one line on.

any help ?

[malcolmcroucher]

just for info its not a problem of being a line out of sinc , if australia is below aruba , the whole of australia gets the wrong number :

Armenia126
Aruba139
Australia99
Australia99
Australia99
Australia99
Australia99
Australia99
Austria186

Where australia should be :

Armenia 139
Aruba 99
Australia 186
Austria 44

[malcolmcroucher]

i sorted it out ,

There was a space in one set of the data

e.g Denmark . and Denmark.