Help With Arrays, real Basic Arrays

I have this set up:

=IF(H3-H9={0,1,2,3,4,5,6,7,8,9},{"I","N","T","Y","AE","AK","AQ","AV","BB","BG"},"INVALID DATE")

If H3 and H9 are the same and equal 0, then the return is I

However, If the H3 and H9 equals 1, the return is INVALID DATE. I want it to be N.

What is this novice doing wrong?

Hi

You need to use a lookup function for this eg:

=IF(ISNA(VLOOKUP(H3-H9,{0,"I";1,"N";2,"T";3,"Y";4,"AE";5,"AK";6,"AQ";7,"AV";8,"BB";9,"BG"},2,0)),"INVALID DATE",VLOOKUP(H3-H9,{0,"I";1,"N";2,"T";3,"Y";4,"AE";5,"AK";6,"AQ";7,"AV";8,"BB";9,"BG"},2,0))

Richard

Wow. Complicated. I'll give it a try though. Thank you.

Worked like a charm. This has helped me immensely. The user can now input a specific Worksheet, and a specific Year from that worksheet and get a pie chart of yearly oil usage.

Fantastic! Thank you so much.