Vlookup equivalent in Access

[Eddie]

I have a table that has a column with 2.5M postcodes and another of the columns has an LSOA code (table 1).



In another table I uploaded a list of 3000 postcodes (in the same format) which I need to identify the corresponding LSOA code. (table2)

In excel I would simply use =Vlookup(b1,table1 a1:c2500000,3,false) and this would return the corresponding LSOA codes required.

How do I do a similar task in Access. I have hardly ever used access in my life so any help or advice would need to be idiot proof

could anyone tell me how to write a query I could call on each time I get a new list of postcodes to match up with LSOA codes.

Eddie

[ButtonMoon]

What you need is called a JOIN. Try something like this:

SELECT Table2.PostCode, Table1.LSOACode
FROM Table2
LEFT OUTER JOIN Table1
ON Table1.PostCode = Table2.PostCode;

[Eddie]

Got it, that seems to work now, I think I may have had formatting issues earlier also.