I'm using VLOOKUP to combine data from 2 years. I want to organize data
across columns, but problems arise when a customer has more than one entry
per year.

Here's what the raw data looks like before using the formula (the dashes
here just separate columns):

2006 -- ID 350 -- NY -- $45
2006 -- ID 350 -- MA -- $100
2007 -- ID 350 -- NY -- $30
2007 -- ID 350 -- MA -- $550

If the formula worked perfectly, it would display:

2006 -- ID 350 -- NY -- $45 -- $30
2006 -- ID 350 -- MA -- $100 -- $550

But instead, it just puts the first 2007 value ($30) in both customer lines:

2006 -- ID 350 -- NY -- $45 -- $30
2006 -- ID 350 -- MA -- $100 -- $30

Here's the formula that I'm using currently, any ideas?

=IF(ISERROR(VLOOKUP($A3,$A$1637:$BN$3465,$J$1,FALS E)),"0",VLOOKUP($A3,$A$1637:$CD$3465,$J$1,FALSE))