How to look up in Access

[raghuprabhu]

I have attached two spreadsheets and a database.

E29 and E31 are dependent on D6 and E27 and I have to update the table (M1:Q60) every year from the tax office. This is for financial 2016.

I want to replicate this in the database.

How do I lookup do it?

Thanks a lot in advance....


E29 has this code....(in the database taxCoefP)

=IF($D$6="NO EXEMPT",VLOOKUP($E$27,$M$7:$O$14,2,TRUE),IF($D$6="HALF LEVY",VLOOKUP($E$27,$M$18:$O$28,2,TRUE),IF($D$6="FULL LEVY",VLOOKUP($E$27,$M$32:$O$40,2,TRUE),IF($D$6="221D",VLOOKUP($E$27,M44:O44,2,TRUE),IF($D$6="MAXIMUM",VLOOKUP($E$27,#REF!,2,TRUE),0)))))


E31 has this code...(in the database taxCoefA)

=IF($D$6="NO EXEMPT",VLOOKUP($E$27,$M$7:$O$14,3,TRUE),IF($D$6="HALF LEVY",VLOOKUP($E$27,$M$18:$O$28,3,TRUE),IF($D$6="FULL LEVY",VLOOKUP($E$27,$M$32:$O$40,3,TRUE),IF($D$6="221D",VLOOKUP($E$27,M44:O44,3,TRUE),0))))

 

[plog]

How do I lookup do it?

The database world is not analogous to the spreadsheet world. Databases require a different mental perspective. My advice is to read through the W3C school for SQL (http://www.w3schools.com/sql/).

I can't make sense of your Excel code, but going off of what you stated is your objective (looking up data), I am certain you will need a query. That link I provided will teach you what they are, how they work and how to set them up. Essentially, you use SQL code (or the graphical interace in Access which writes SQL code for you) to programmatically tie your tables together and retrieve the data you want.