I'm creating a formula which when there is an "X" in D8, it looks at B5 which
is the year and if that year matched with a heading in Row 6, take the
relevant price, if no match leave blank.

I need to match 8 years (2010 - 2017) and the formula will not allow me to
match more than 3, does anyone have a suggestion of how I can change my
formula to include all years ?

=IF((D8="x"),IF($B$5=$J$6,J8,IF($B$5=$K$6,K8,IF($B $5=$L$6,L8)))," ")

Thanks so much