Vlookup function in access
Thank you for taking the time to report an issue.
What's wrong... Please write below.
=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:
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
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?
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
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.
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.
Please help. Also, I am newbie using Access, so keep that in mind if you find my question to be very basic
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.
I receive about a dozen reports from different companies, all of them in their own format. Up until now, I have been using excel's vlookup function to convert their codes unto my codes. For example, they might designate a value of RNWL which in our system is RWL.
I think I am supposed to be using the dlookup function - can't make it work, though. is there a simpler way to do it
Essentially I am wanting to perform what in excel would be a vlookup function where I pull the information from one query and put it into another query using the date as the lookup criteria.
Eg: Query 1 has the information and Query 2 is where I want to put it.
19 May 2010 996.00
21 June 2010 1101.01
31 August 2010 701.03
Now in Query 2 I want to perform the lookup so the result will look like this
20 June 2010 996.00
21 June 2010 1101.01
22 June 2010 1101.01