This is a first post for me, so apologies if I am unclear in my question...I am using a heat map to plot some data that shows traffic to areas at specific times of the day. I am using a 24 hour reference in a drop down menu to select the time frame that I'm wanting to see activity for, which shows the numbers in relation to the activity of certain areas.

The issue is that I am getting inconsistent returns for some hours and not others...so I will get a #N/A if I select 11:00 but not if I select 12:00, or all hours will work up until 23:00 after which will give the #N/A error. I have attempted to use a '0', '1' and '-1' in at the end of the MATCH formula as well as just leaving it blank.

Nothing seems to give me a consistent return.

Below is the formula that I'm using, but have a feeling that there is something else that I am overlooking in regards to the inconsistent return.

=INDEX(NUMBERS!E76:AB76,MATCH(G5,NUMBERS!E2:AB2,0))

Any assistance at this junction would be greatly appreciated!