J
Julie HSV
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
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