Need help please, IF true THEN MATCH from list and put PRICE in CELL

[LAMESARVSALES]

If the date (D3) is 2015 THEN MATCH (F3) WITH TABLE (Q3) AND put the adjacent amount from (R3) in CELL (O3)

A B C D E F G H I J K L M N O

[TABLE="width: 1310"]
<tbody>[TR]
[TD]ADays[/TD]
[TD]BRec[/TD]
[TD]CStock #[/TD]
[TD]DYear[/TD]
[TD]EMake[/TD]
[TD]FModel Description[/TD]
[TD]GModel[/TD]
[TD]HSCDE[/TD]
[TD]ILocation[/TD]
[TD]JList $$[/TD]
[TD]KAd $$[/TD]
[TD="align: right"]L2014[/TD]
[TD="align: right"]M2015[/TD]
[TD="align: right"]N2016[/TD]
[TD]OSpiff[/TD]
[TD]P[/TD]
[TD]Q manufacturer[/TD]
[TD]R amount[/TD]
[/TR]
[TR]
[TD]64[/TD]
[TD="align: right"]06/29/15[/TD]
[TD]SNA78787[/TD]
[TD="align: right"]2015[/TD]
[TD]Allegro[/TD]
[TD]TOUR[/TD]
[TD]31SA[/TD]
[TD]GDF2[/TD]
[TD]SD[/TD]
[TD="align: right"]160,827[/TD]
[TD]133,769[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD](NO MATCH)[/TD]
[TD][/TD]
[TD]TOUR[/TD]
[TD="align: right"]5000[/TD]
[/TR]
[TR]
[TD]49[/TD]
[TD="align: right"]07/14/15[/TD]
[TD]VNA79072[/TD]
[TD="align: right"]2016[/TD]
[TD]Allegro[/TD]
[TD]ELLIPSE[/TD]
[TD]31SA[/TD]
[TD]GDF2[/TD]
[TD]PHX[/TD]
[TD="align: right"]160,827[/TD]
[TD]133,098[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD](NO MATCH)[/TD]
[TD][/TD]
[TD]ELLIPSE[/TD]
[TD="align: right"]5000[/TD]
[/TR]
[TR]
[TD]41[/TD]
[TD="align: right"]07/22/15[/TD]
[TD]SNA79242[/TD]
[TD="align: right"]2016[/TD]
[TD]Allegro[/TD]
[TD]JOURNEY[/TD]
[TD]31SA[/TD]
[TD]GDF2[/TD]
[TD]SD[/TD]
[TD="align: right"]159,703[/TD]
[TD]132,848[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD](NO MATCH)[/TD]
[TD][/TD]
[TD]JOURNEY[/TD]
[TD="align: right"]3000[/TD]
[/TR]
[TR]
[TD]26[/TD]
[TD="align: right"]08/06/15[/TD]
[TD]FNA79559[/TD]
[TD="align: right"]2016[/TD]
[TD]Allegro[/TD]
[TD]OPEN ROAD[/TD]
[TD]31SA[/TD]
[TD]GDF2[/TD]
[TD]ORL/1[/TD]
[TD="align: right"]163,437[/TD]
[TD]135,258[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD](NO MATCH)[/TD]
[TD][/TD]
[TD]MERIDIAN[/TD]
[TD="align: right"]3000[/TD]
[/TR]
[TR]
[TD]13[/TD]
[TD="align: right"]08/19/15[/TD]
[TD]FNA79941[/TD]
[TD="align: right"]2016[/TD]
[TD]Allegro[/TD]
[TD]OPEN ROAD[/TD]
[TD]31SA[/TD]
[TD]GTF2[/TD]
[TD]ORL/1[/TD]
[TD="align: right"]163,292[/TD]
[TD]135,138[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD](NO MATCH)[/TD]
[TD][/TD]
[TD]FORZA[/TD]
[TD="align: right"]2500[/TD]
[/TR]
[TR]
[TD]8[/TD]
[TD="align: right"]08/24/15[/TD]
[TD]MNA79946[/TD]
[TD="align: right"]2016[/TD]
[TD]Allegro[/TD]
[TD]OPEN ROAD[/TD]
[TD]31SA[/TD]
[TD]GDF2[/TD]
[TD]MES[/TD]
[TD="align: right"]159,957[/TD]
[TD]132,378[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD](NO MATCH)[/TD]
[TD][/TD]
[TD]SOLEI[/TD]
[TD="align: right"]2500[/TD]
[/TR]
[TR]
[TD]6[/TD]
[TD="align: right"]08/26/15[/TD]
[TD]TNA80046[/TD]
[TD="align: right"]2016[/TD]
[TD]Allegro[/TD]
[TD]OPEN ROAD[/TD]
[TD]31SA[/TD]
[TD]GDF2[/TD]
[TD]TUC[/TD]
[TD="align: right"]159,957[/TD]
[TD]132,378[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD](NO MATCH)[/TD]
[TD][/TD]
[TD]VIVA[/TD]
[TD="align: right"]1500[/TD]
[/TR]
[TR]
[TD]112[/TD]
[TD="align: right"]05/12/15[/TD]
[TD]VNA77294[/TD]
[TD="align: right"]2015[/TD]
[TD]Allegro[/TD]
[TD]OPEN ROAD[/TD]
[TD]32CA[/TD]
[TD]GTF2[/TD]
[TD]SD[/TD]
[TD="align: right"]156,252[/TD]
[TD]115,998[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD](NO MATCH)[/TD]
[TD][/TD]
[TD]ADVENTURER[/TD]
[TD="align: right"]1000[/TD]
[/TR]
[TR]
[TD]98[/TD]
[TD="align: right"]05/26/15[/TD]
[TD]SNA77899[/TD]
[TD="align: right"]2015[/TD]
[TD]Allegro[/TD]
[TD]OPEN ROAD[/TD]
[TD]32SA[/TD]
[TD]GDF2[/TD]
[TD]SD[/TD]
[TD="align: right"]159,631[/TD]
[TD]124,998[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD](NO MATCH)[/TD]
[TD][/TD]
[TD]SUNCRUISER[/TD]
[TD="align: right"]1000[/TD]
[/TR]
[TR]
[TD]92[/TD]
[TD="align: right"]06/01/15[/TD]
[TD]MNA78039[/TD]
[TD="align: right"]2016[/TD]
[TD]Allegro[/TD]
[TD]OPEN ROAD[/TD]
[TD]32SA[/TD]
[TD]GDF2[/TD]
[TD]PHX[/TD]
[TD="align: right"]165,177[/TD]
[TD]136,766[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]5[/TD]
[TD](NO MATCH)[/TD]
[TD][/TD]
[TD]SIGHTSEER[/TD]
[TD="align: right"]1000[/TD]
[/TR]
[TR]
[TD]85[/TD]
[TD="align: right"]06/08/15[/TD]
[TD]SNA78331[/TD]
[TD="align: right"]2016[/TD]
[TD]Allegro[/TD]
[TD]OPEN ROAD[/TD]
[TD]32SA[/TD]
[TD]GDF2[/TD]
[TD]SD[/TD]
[TD="align: right"]169,237[/TD]
[TD]140,736[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD](NO MATCH)[/TD]
[TD][/TD]
[TD]SUNOVA[/TD]
[TD="align: right"]1000[/TD]
[/TR]
[TR]
[TD]77[/TD]
[TD="align: right"]06/16/15[/TD]
[TD]TNA78250[/TD]
[TD="align: right"]2016[/TD]
[TD]Allegro[/TD]
[TD]OPEN ROAD[/TD]
[TD]32SA[/TD]
[TD]GDF2[/TD]
[TD]TUC[/TD]
[TD="align: right"]165,177[/TD]
[TD]137,526[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD](NO MATCH)[/TD]
[TD][/TD]
[TD]ASPECT[/TD]
[TD="align: right"]1000[/TD]
[/TR]
[TR]
[TD]77[/TD]
[TD="align: right"]06/16/15[/TD]
[TD]VNA78425[/TD]
[TD="align: right"]2016[/TD]
[TD]Allegro[/TD]
[TD]OPEN ROAD[/TD]
[TD]32SA[/TD]
[TD]GDF2[/TD]
[TD]MES[/TD]
[TD="align: right"]165,177[/TD]
[TD]136,698[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD](NO MATCH)[/TD]
[TD][/TD]
[TD]CAMBRIA[/TD]
[TD="align: right"]1000[/TD]
[/TR]
[TR]
[TD]67[/TD]
[TD="align: right"]06/26/15[/TD]
[TD]FNA78700[/TD]
[TD="align: right"]2016[/TD]
[TD]Allegro[/TD]
[TD]OPEN ROAD[/TD]
[TD]32SA[/TD]
[TD]GTF2[/TD]
[TD]ORL/1[/TD]
[TD="align: right"]167,642[/TD]
[TD]138,738[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD](NO MATCH)[/TD]
[TD][/TD]
[TD]LUXE[/TD]
[TD="align: right"]3000[/TD]
[/TR]
[TR]
[TD]7[/TD]
[TD="align: right"]08/25/15[/TD]
[TD]MNA79947[/TD]
[TD="align: right"]2016[/TD]
[TD]Allegro[/TD]
[TD]OPEN ROAD[/TD]
[TD]32SA[/TD]
[TD]GDF2[/TD]
[TD]MES[/TD]
[TD="align: right"]165,177[/TD]
[TD]136,698[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD](NO MATCH)[/TD]
[TD][/TD]
[TD]LIFESTYLE[/TD]
[TD="align: right"]5000[/TD]
[/TR]
[TR]
[TD]8[/TD]
[TD="align: right"]08/24/15[/TD]
[TD]VNA80041[/TD]
[TD="align: right"]2016[/TD]
[TD]Allegro[/TD]
[TD]OPEN ROAD[/TD]
[TD]32SA[/TD]
[TD]GDF2[/TD]
[TD]PHX[/TD]
[TD="align: right"]165,177[/TD]
[TD]136,698[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD](NO MATCH)[/TD]
[TD][/TD]
[TD]TESLA[/TD]
[TD="align: right"]3000[/TD]
[/TR]
[TR]
[TD]120[/TD]
[TD="align: right"]05/04/15[/TD]
[TD]SNA77182[/TD]
[TD="align: right"]2015[/TD]
[TD]Allegro[/TD]
[TD]OPEN ROAD[/TD]
[TD]35QBA[/TD]
[TD]GDF4[/TD]
[TD]SD[/TD]
[TD="align: right"]163,582[/TD]
[TD]124,998[/TD]
[TD="align: right"]5[/TD]
[TD="align: right"]5[/TD]
[TD="align: right"]0[/TD]
[TD](NO MATCH)[/TD]
[TD][/TD]
[TD]HILL[/TD]
[TD="align: right"]1500[/TD]
[/TR]
[TR]
[TD]8[/TD]
[TD="align: right"]08/24/15[/TD]
[TD]FNA80035[/TD]
[TD="align: right"]2016[/TD]
[TD]Allegro[/TD]
[TD]OPEN ROAD[/TD]
[TD]35QBA[/TD]
[TD]GDF4[/TD]
[TD]ORL/1[/TD]
[TD="align: right"]169,599[/TD]
[TD]140,358[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD](NO MATCH)[/TD]
[TD][/TD]
[TD]AMPED[/TD]
[TD="align: right"]1000[/TD]
[/TR]
[TR]
[TD]288[/TD]
[TD="align: right"]11/17/14[/TD]
[TD]VNA71761[/TD]
[TD="align: right"]2015[/TD]
[TD]Allegro[/TD]
[TD]OPEN ROAD[/TD]
[TD]36LA[/TD]
[TD]GTF2[/TD]
[TD]PHX[/TD]
[TD="align: right"]164,488[/TD]
[TD]124,998[/TD]
[TD="align: right"]15[/TD]
[TD="align: right"]15[/TD]
[TD="align: right"]0[/TD]
[TD](NO MATCH)[/TD]
[TD][/TD]
[TD]REACTOR[/TD]
[TD="align: right"]1000[/TD]
[/TR]
[TR]
[TD]105[/TD]
[TD="align: right"]05/19/15[/TD]
[TD]TNA77657[/TD]
[TD="align: right"]2015[/TD]
[TD]Allegro[/TD]
[TD]OPEN ROAD[/TD]
[TD]36LA[/TD]
[TD]GDF2[/TD]
[TD]TUC[/TD]
[TD="align: right"]169,672[/TD]
[TD]129,998[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD](NO MATCH)[/TD]
[TD][/TD]
[TD]RENEGADE[/TD]
[TD="align: right"]2500[/TD]
[/TR]
[TR]
[TD]69[/TD]
[TD="align: right"]06/24/15[/TD]
[TD]MNA78592[/TD]
[TD="align: right"]2016[/TD]
[TD]Allegro[/TD]
[TD]OPEN ROAD[/TD]
[TD]36LA[/TD]
[TD]GTF2[/TD]
[TD]MES[/TD]
[TD="align: right"]177,067[/TD]
[TD]146,538[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD](NO MATCH)[/TD]
[TD][/TD]
[TD]DISCOVERY[/TD]
[TD="align: right"]3000[/TD]
[/TR]
[TR]
[TD]54[/TD]
[TD="align: right"]07/09/15[/TD]
[TD]TNA78510[/TD]
[TD="align: right"]2016[/TD]
[TD]Allegro[/TD]
[TD]OPEN ROAD[/TD]
[TD]36LA[/TD]
[TD]GTF2[/TD]
[TD]TUC[/TD]
[TD="align: right"]177,067[/TD]
[TD]147,355[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD](NO MATCH)[/TD]
[TD][/TD]
[TD]BOUNDER[/TD]
[TD="align: right"]1500[/TD]
[/TR]
[TR]
[TD]41[/TD]
[TD="align: right"]07/22/15[/TD]
[TD]FNA79238[/TD]
[TD="align: right"]2016[/TD]
[TD]Allegro[/TD]
[TD]OPEN ROAD[/TD]
[TD]36LA[/TD]
[TD]GDF2[/TD]
[TD]ORL/1[/TD]
[TD="align: right"]169,454[/TD]
[TD]140,238[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD](NO MATCH)[/TD]
[TD][/TD]
[TD]LATITUDE[/TD]
[TD="align: right"]1000[/TD]
[/TR]
[TR]
[TD]40[/TD]
[TD="align: right"]07/23/15[/TD]
[TD]VNA79252[/TD]
[TD="align: right"]2016[/TD]
[TD]Allegro[/TD]
[TD]OPEN ROAD[/TD]
[TD]36LA[/TD]
[TD]GTF2[/TD]
[TD]PHX[/TD]
[TD="align: right"]171,774[/TD]
[TD]142,158[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD](NO MATCH)[/TD]
[TD][/TD]
[TD]DESTINATION[/TD]
[TD="align: right"]1000[/TD]
[/TR]
[TR]
[TD]1[/TD]
[TD="align: right"]08/31/15[/TD]
[TD]SNA81186[/TD]
[TD="align: right"]2016[/TD]
[TD]Allegro[/TD]
[TD]OPEN ROAD[/TD]
[TD]36LA[/TD]
[TD]GTF2[/TD]
[TD]SD/RECON[/TD]
[TD="align: right"]173,514[/TD]
[TD][/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD](NO MATCH)[/TD]
[TD][/TD]
[TD]BUS[/TD]
[TD="align: right"]3000[/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD](NO MATCH)[/TD]
[TD][/TD]
[TD]RED[/TD]
[TD="align: right"]2000[/TD]
[/TR]
[TR]
[TD]200[/TD]
[TD="align: right"]02/13/15[/TD]
[TD]VNA74414[/TD]
[TD="align: right"]2015[/TD]
[TD]Allegro[/TD]
[TD]MH PHAETON[/TD]
[TD]36GH[/TD]
[TD]DDL4[/TD]
[TD]SD[/TD]
[TD="align: right"]304,283[/TD]
[TD]219,998[/TD]
[TD="align: right"]15[/TD]
[TD="align: right"]15[/TD]
[TD="align: right"]0[/TD]
[TD](NO MATCH)[/TD]
[TD][/TD]
[TD]PHAETON[/TD]
[TD="align: right"]2500[/TD]
[/TR]
[TR]
[TD]104[/TD]
[TD="align: right"]05/20/15[/TD]
[TD]MNA77693[/TD]
[TD="align: right"]2015[/TD]
[TD]Allegro[/TD]
[TD]MH PHAETON[/TD]
[TD]36GH[/TD]
[TD]DTL4[/TD]
[TD]MES[/TD]
[TD="align: right"]304,283[/TD]
[TD]224,998[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD](NO MATCH)[/TD]
[TD][/TD]
[TD]OPEN ROAD[/TD]
[TD="align: right"]1500[/TD]
[/TR]
[TR]
[TD]96[/TD]
[TD="align: right"]05/28/15[/TD]
[TD]TNA77749[/TD]
[TD="align: right"]2015[/TD]
[TD]Allegro[/TD]
[TD]MH PHAETON[/TD]
[TD]36GH[/TD]
[TD]DDL4[/TD]
[TD]TUC[/TD]
[TD="align: right"]303,558[/TD]
[TD]224,998[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD](NO MATCH)[/TD]
[TD][/TD]
[TD]ROADTRED[/TD]
[TD="align: right"]2000[/TD]
[/TR]
[TR]
[TD]54[/TD]
[TD="align: right"]07/09/15[/TD]
[TD]FNA78970[/TD]
[TD="align: right"]2016[/TD]
[TD]Allegro[/TD]
[TD]MH PHAETON[/TD]
[TD]36GH[/TD]
[TD]DTL4[/TD]
[TD]ORL/FACTORY[/TD]
[TD="align: right"]305,479[/TD]
[TD]235,956[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD](NO MATCH)[/TD]
[TD][/TD]
[TD]LANDMARK[/TD]
[TD="align: right"]1750[/TD]
[/TR]
[TR]
[TD]53[/TD]
[TD="align: right"]07/10/15[/TD]
[TD]SNA79002[/TD]
[TD="align: right"]2016[/TD]
[TD]Allegro[/TD]
[TD]MH PHAETON[/TD]
[TD]36GH[/TD]
[TD]DTL4[/TD]
[TD]PHX[/TD]
[TD="align: right"]305,479[/TD]
[TD]237,181[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD](NO MATCH)[/TD]
[TD][/TD]
[TD]BIG[/TD]
[TD="align: right"]1000[/TD]
[/TR]
[TR]
[TD]13[/TD]
[TD="align: right"]08/19/15[/TD]
[TD]SNA79952[/TD]
[TD="align: right"]2016[/TD]
[TD]Allegro[/TD]
[TD]MH PHAETON[/TD]
[TD]36GH[/TD]
[TD]DTL4[/TD]
[TD]SD/RECON[/TD]
[TD="align: right"]309,285[/TD]
[TD]240,108[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD](NO MATCH)[/TD]
[TD][/TD]
[TD]CYCLONE[/TD]
[TD="align: right"]1000[/TD]
[/TR]
[TR]
[TD]123[/TD]
[TD="align: right"]05/01/15[/TD]
[TD]FNA77113[/TD]
[TD="align: right"]2015[/TD]
[TD]Allegro[/TD]
[TD]MH PHAETON[/TD]
[TD]40AH[/TD]
[TD]DTL4[/TD]
[TD]ORL/1[/TD]
[TD="align: right"]311,678[/TD]
[TD]229,998[/TD]
[TD="align: right"]5[/TD]
[TD="align: right"]5[/TD]
[TD="align: right"]0[/TD]
[TD](NO MATCH)[/TD]
[TD][/TD]
[TD]VOLTAGE[/TD]
[TD="align: right"]2000[/TD]
[/TR]
[TR]
[TD]117[/TD]
[TD="align: right"]05/07/15[/TD]
[TD]TNA77083[/TD]
[TD="align: right"]2015[/TD]
[TD]Allegro[/TD]
[TD]MH PHAETON[/TD]
[TD]40AH[/TD]
[TD]DTL4[/TD]
[TD]TUC[/TD]
[TD="align: right"]311,678[/TD]
[TD]229,998[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD](NO MATCH)[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]105[/TD]
[TD="align: right"]05/19/15[/TD]
[TD]VNA77709[/TD]
[TD="align: right"]2015[/TD]
[TD]Allegro[/TD]
[TD]MH PHAETON[/TD]
[TD]40AH[/TD]
[TD]DDL4[/TD]
[TD]PHX[/TD]
[TD="align: right"]321,175[/TD]
[TD]239,998[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD](NO MATCH)[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]75[/TD]
[TD="align: right"]06/18/15[/TD]
[TD]VNA78489[/TD]
[TD="align: right"]2016[/TD]
[TD]Allegro[/TD]
[TD]MH PHAETON[/TD]
[TD]40AH[/TD]
[TD]DTL4[/TD]
[TD]PHX[/TD]
[TD="align: right"]318,819[/TD]
[TD]246,260[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD](NO MATCH)[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]70[/TD]
[TD="align: right"]06/23/15[/TD]
[TD]MNA78591[/TD]
[TD="align: right"]2016[/TD]
[TD]Allegro[/TD]
[TD]MH PHAETON[/TD]
[TD]40AH[/TD]
[TD]DTL4[/TD]
[TD]MES[/TD]
[TD="align: right"]315,883[/TD]
[TD]243,992[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD](NO MATCH)[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]69[/TD]
[TD="align: right"]06/24/15[/TD]
[TD]SNA78683[/TD]
[TD="align: right"]2016[/TD]
[TD]Allegro[/TD]
[TD]MH PHAETON[/TD]
[TD]40AH[/TD]
[TD]DTL4[/TD]
[TD]SD[/TD]
[TD="align: right"]318,819[/TD]
[TD]247,428[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD](NO MATCH)[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]34[/TD]
[TD="align: right"]07/29/15[/TD]
[TD]FNA79363[/TD]
[TD="align: right"]2016[/TD]
[TD]Allegro[/TD]
[TD]MH PHAETON[/TD]
[TD]40AH[/TD]
[TD]DTL4[/TD]
[TD]ORL/1[/TD]
[TD="align: right"]318,819[/TD]
[TD]246,260[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD](NO MATCH)[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]21[/TD]
[TD="align: right"]08/11/15[/TD]
[TD]MNA79686[/TD]
[TD="align: right"]2016[/TD]
[TD]Allegro[/TD]
[TD]MH PHAETON[/TD]
[TD]40AH[/TD]
[TD]FFL4[/TD]
[TD]MES[/TD]
[TD="align: right"]327,338[/TD]
[TD]252,840[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD](NO MATCH)[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]


Thanks everyone!

 

[ArthriticPanda]

Hi,

Try something like this:

Excel Workbook
	A	B	C	D	E	F	G	H	I	J	K	L	M	N	O	P	Q	R
1	ADays	BRec	CStock #	DYear	EMake	FModel Description	GModel	HSCDE	ILocation	JList $$	KAd $$	L2014	M2015	N2016	OSpiff	P	Q manufacturer	R amount
2	64	06/29/15	SNA78787	2015	Allegro	TOUR	31SA	GDF2	SD	160,827	133,769	0	0	0	5000		TOUR	5000
3	49	07/14/15	VNA79072	2016	Allegro	ELLIPSE	31SA	GDF2	PHX	160,827	133,098	0	0	0	0		ELLIPSE	5000
4	41	07/22/15	SNA79242	2016	Allegro	JOURNEY	31SA	GDF2	SD	159,703	132,848	0	0	0	0		JOURNEY	3000
5	26	08/06/2015	FNA79559	2016	Allegro	OPEN ROAD	31SA	GDF2	ORL/1	163,437	135,258	0	0	0	0		MERIDIAN	3000
6	13	08/19/15	FNA79941	2016	Allegro	OPEN ROAD	31SA	GTF2	ORL/1	163,292	135,138	0	0	0	0		FORZA	2500
7	8	08/24/15	MNA79946	2016	Allegro	OPEN ROAD	31SA	GDF2	MES	159,957	132,378	0	0	0	0		SOLEI	2500
8	6	08/26/15	TNA80046	2016	Allegro	OPEN ROAD	31SA	GDF2	TUC	159,957	132,378	0	0	0	0		VIVA	1500
9	112	05/12/2015	VNA77294	2015	Allegro	OPEN ROAD	32CA	GTF2	SD	156,252	115,998	0	0	0	1500		ADVENTURER	1000
10	98	05/26/15	SNA77899	2015	Allegro	OPEN ROAD	32SA	GDF2	SD	159,631	124,998	0	0	0	1500		SUNCRUISER	1000
11	92	06/01/2015	MNA78039	2016	Allegro	OPEN ROAD	32SA	GDF2	PHX	165,177	136,766	0	0	5	0		SIGHTSEER	1000
12	85	06/08/2015	SNA78331	2016	Allegro	OPEN ROAD	32SA	GDF2	SD	169,237	140,736	0	0	0	0		SUNOVA	1000
13	77	06/16/15	TNA78250	2016	Allegro	OPEN ROAD	32SA	GDF2	TUC	165,177	137,526	0	0	0	0		ASPECT	1000
14	77	06/16/15	VNA78425	2016	Allegro	OPEN ROAD	32SA	GDF2	MES	165,177	136,698	0	0	0	0		CAMBRIA	1000
15	67	06/26/15	FNA78700	2016	Allegro	OPEN ROAD	32SA	GTF2	ORL/1	167,642	138,738	0	0	0	0		LUXE	3000
16	7	08/25/15	MNA79947	2016	Allegro	OPEN ROAD	32SA	GDF2	MES	165,177	136,698	0	0	0	0		LIFESTYLE	5000
17	8	08/24/15	VNA80041	2016	Allegro	OPEN ROAD	32SA	GDF2	PHX	165,177	136,698	0	0	0	0		TESLA	3000
18	120	05/04/2015	SNA77182	2015	Allegro	OPEN ROAD	35QBA	GDF4	SD	163,582	124,998	5	5	0	1500		HILL	1500
19	8	08/24/15	FNA80035	2016	Allegro	OPEN ROAD	35QBA	GDF4	ORL/1	169,599	140,358	0	0	0	0		AMPED	1000
20	288	11/17/14	VNA71761	2015	Allegro	OPEN ROAD	36LA	GTF2	PHX	164,488	124,998	15	15	0	1500		REACTOR	1000
21	105	05/19/15	TNA77657	2015	Allegro	OPEN ROAD	36LA	GDF2	TUC	169,672	129,998	0	0	0	1500		RENEGADE	2500
22	69	06/24/15	MNA78592	2016	Allegro	OPEN ROAD	36LA	GTF2	MES	177,067	146,538	0	0	0	0		DISCOVERY	3000
23	54	07/09/2015	TNA78510	2016	Allegro	OPEN ROAD	36LA	GTF2	TUC	177,067	147,355	0	0	0	0		BOUNDER	1500
24	41	07/22/15	FNA79238	2016	Allegro	OPEN ROAD	36LA	GDF2	ORL/1	169,454	140,238	0	0	0	0		LATITUDE	1000
25	40	07/23/15	VNA79252	2016	Allegro	OPEN ROAD	36LA	GTF2	PHX	171,774	142,158	0	0	0	0		DESTINATION	1000
26	1	08/31/15	SNA81186	2016	Allegro	OPEN ROAD	36LA	GTF2	SD/RECON	173,514		0	0	0	0		BUS	3000
Sheet1

AP

 

[DRSteele]

The function VLOOKUP was tailor-made for tasks like this. In O2 put this and copy down =IF(D2=2015,VLOOKUP(F2,$Q:$R,2,0),"not 2015")

 

[mumps]

VBA approach:

Sub CopyCell()
    Application.ScreenUpdating = False
    Dim LastRow As Long
    LastRow = Cells.Find("*", SearchOrder:=xlByRows, SearchDirection:=xlPrevious).Row
    Dim rng As Range
    For Each rng In Range("D2:D" & LastRow)
        If rng = "2015" And rng.Offset(0, 2) = rng.Offset(0, 13) Then
            rng.Offset(0, 11) = rng.Offset(0, 14)
        Else
            rng.Offset(0, 11) = "NO MATCH"
        End If
    Next rng
    Application.ScreenUpdating = True
End Sub