V Lookup
 

While updating my Access database with information from an excel file, I have
lost my place where I was in updating. I have exported my Access list into a
worksheet in the same file as the excel information. I need to know how to
lookup to see if column A in the excel copy has any matches in column A of
the Database info. The tabs are OLD and DATABASE. I've tried
=vlookup(A1,OLD,A1:A6000,FALSE). Help?

V Lookup
 

Hi,

=vlookup(A1,OLD!A1:A6000,1,FALSE)

"Alberta Rose" wrote:

While updating my Access database with information from an excel file, I have
lost my place where I was in updating. I have exported my Access list into a
worksheet in the same file as the excel information. I need to know how to
lookup to see if column A in the excel copy has any matches in column A of
the Database info. The tabs are OLD and DATABASE. I've tried
=vlookup(A1,OLD,A1:A6000,FALSE). Help?

V Lookup
 

Thanks Eduardo! One more thing, when my database info downloaded into excel,
some of the fields came over as text. How do I change them to numeric?

"Eduardo" wrote:

Hi,

=vlookup(A1,OLD!A1:A6000,1,FALSE)

"Alberta Rose" wrote:

While updating my Access database with information from an excel file, I have
lost my place where I was in updating. I have exported my Access list into a
worksheet in the same file as the excel information. I need to know how to
lookup to see if column A in the excel copy has any matches in column A of
the Database info. The tabs are OLD and DATABASE. I've tried
=vlookup(A1,OLD,A1:A6000,FALSE). Help?

V Lookup
 

Hi Alberta,
you can highlight it, right click on the mouse and then choose general or
number, but sometimes the text comes with some blank spaces at the beginning
in that case in anothe column enter

=Trim(A1)

copy formula down and then copy and paste as value in the original column

hope this helps

"Alberta Rose" wrote:

Thanks Eduardo! One more thing, when my database info downloaded into excel,
some of the fields came over as text. How do I change them to numeric?

"Eduardo" wrote:

Hi,

=vlookup(A1,OLD!A1:A6000,1,FALSE)

"Alberta Rose" wrote:

While updating my Access database with information from an excel file, I have
lost my place where I was in updating. I have exported my Access list into a
worksheet in the same file as the excel information. I need to know how to
lookup to see if column A in the excel copy has any matches in column A of
the Database info. The tabs are OLD and DATABASE. I've tried
=vlookup(A1,OLD,A1:A6000,FALSE). Help?