Recieving inconsistent #N/A error using Index Match with 24 hour clock reference

[Baracudabill]

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!

[Ron Coderre]

Can you post a sample workbook containing the contents of NUMBERS!E2:AB2 and G5?

[Baracudabill]

Attached is a sample of the workbook that I am attempting...hope this give an indication as to what I'm trying to accomplish.

[Baracudabill]

Finally figured out what I was doing incorrectly...was referencing a list that was created on separate tab...which is fine for any other list I've created in the past, but I guess excel was having some issues seeing the exact match. So I built a new list from the "Match" reference for the Drop down menu and seems to have cleared up the inconsistency.

[Ron Coderre]

Glad you figured it out.
I'll mark this thread "solved" for you