| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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? |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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? |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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? |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| LOOKUP FUNCTION? (LOOKUP VALUE BEING A TIME RENERATED FROM A FORMU | Excel Discussion (Misc queries) | |||
| Lookup looks to the prior column if zero appears in the lookup col | Excel Discussion (Misc queries) | |||
| Matrix lookup/mulitple criteria lookup | Excel Discussion (Misc queries) | |||
| Join 2 Lists - Lookup value in 1 list & use result in 2nd lookup | Excel Worksheet Functions | |||
| Pivot table doing a lookup without using the lookup function? | Excel Discussion (Misc queries) | |||
Linear Mode
