Topics Search

Vlookup function in access

Vlookup function in access
Views: 122
I have table with customers and orders. I want to fill automaticaly fields like Name, address, etc. when I fill customer number in form new order. In excel I use for this Vlook up function but I dont know how to do it in access.
Sponsored Links:

More topics

 

convert vlookup to access

Preview
I have an Excel formula that I need to convert to Access 2007:

=IF(F8="Active",IF(AND(C8<>"None",C8<>"COM"),VLOOK UP(N8,AQ6:AV11,L8+1,FALSE ),IF(C8="COM",VLOOKUP(J8,AX7:AY11,2,),"Error")),"N ull")

The vlookup looks to this:
AQ6:AV11
AX7:AY11

The cell references like C8,N8 are values in the first column of the vlookup fields. This is for a ratings table.

It took me a while to figure out vlookup and it's real cool, but not in Access. I know I would have to use VBA to reproduce this, but umh not brainy enough
 

How to use vlookup to find your criteria?

Preview
I need want to use the vlookup function in Access 2010 when creating a query. I am doing this as an expression in design view of my query.

to first, ask what state I am looking for (I have put this in the criteria box of the field "[State]"), then search anothertable (I have it created already, it is a list of the states) for that state and plug the cell with the name of that state into this new query cell.

How can you do this?
 

Simple VLookup function in Access

Preview
I would like to know how to write a query to run a simple vlookup functions between these two:

Tabel1 : has 200,000 rows of data. Has the fields to be looked up- "Serial_Number" and "Ship_Date"

Table2: has the field :"Serial_No"

I want table3 to Lookup Serial_No (tabel2) in the Serial_Number in table1 and return the corresponding row value of Ship_Date
 

When uses Vlookup

Preview
I have imported lots of data into multiple tables in Access. For each line item, I have a Sale Date. Our Sales Dates need to be organized by a predetermined Week Number and Period Number. I have an excel file with a list of each date for the year with what Week it falls in, as well as what Period. How can I add this to Access for a new column with all my data, and then when new data comes in each data, it assigns it automatically.

Would I use Vlookup?

FYI- there is no way I can export this data into excel and use vlookup and reimport, I have over 1 million rows of data.
 

Query to work as a Vlookup function

Preview
Given:
One table with following fields:
System, Component, Anomaly number, Status, Priority.

I have a form with first two fields as system and component. You can select each with from drop down menus.

Question:
I would like to create more fields in this form, where I can choose system and component and display anomaly numbers associated to them and their respective status and priority.

I can do this in excel using VLOOKUP. Tried using DLOOKUP in access but cannot get it to work.

Please help. Also, I am newbie using Access, so keep that in mind if you find my question to be very basic
 

Query to work as a Vlookup function

Preview
One table with following fields:
System, Component, Anomaly number, Status, Priority.

I have a form with first two fields as system and component. You can select each with from drop down menus.

I would like to create more fields in this form, where I can choose system and component and display anomaly numbers associated to them and their respective status and priority.

I can do this in excel using VLOOKUP. Tried using DLOOKUP in access but cannot get it to work.
 

Query with Vlookup formula

Preview
I am new with access and I would like to make a question to see if it is possible to create a query that contains the a formula similar to the vlookup formula in excel.
I have to create a data base with three different tables that include different information from the same people, so then I would like to create a query to see if the same people is included effectively in the others tables or not. If I have to do this excel I would use the vlookup, however I need to do this in acess because based on this information there will be several actions to take from that point.
 

Excel VLookup vs Access IIF statement

Preview
I have an excel formula that I used a VLookup to calculate the Fiscal Year(FY) of a signed document. I changed it to an IIF statement for Access but the Query won't accept it as an expression because of it's size. Is there another way to accomplish this?
 

understanding excel for access purposes

Preview
I need to make a form in access related to the records from excel. I need the operations to be exactly the same from excel so I could convert the calculations in ms access. but I don't know what this means? =(IF(ISNA(VLOOKUP(G12,$AI$9:$AJ$10, 2, 0)),0,VLOOKUP(G12,$AI$9:$AJ$10, 2, 0))) it's from one of the calculations in excel. I just want to understand what the logic is about. any help would do
 

understanding excel for access purposes

Preview
I need to make a form in access related to the records from excel. I need the operations to be exactly the same from excel so I could convert the calculations in ms access. but I don't know what this means? =(IF(ISNA(VLOOKUP(G12,$AI$9:$AJ$10, 2, 0)),0,VLOOKUP(G12,$AI$9:$AJ$10, 2, 0))) it's from one of the calculations in excel.