Getting #n/a on lookup

[troyakaTB]

I am getting #n/a on a lookup I am using. It is not on all values and cannot determine what is causing it. I have attached a copy. In E1 the date is entered. The lookup is supposed to get a value in B3 based on the month entered. It works on some months but not all and I get a 0 on a couple instead of the value. Thanks for the help.

TB

[JieJenn]

Try

=INDEX('Metric Scores'!$C$5:$N$5,MATCH(I1,'Metric Scores'!$C$4:$N$4,0))

[troyakaTB]

Thanks, that works. Do you know why the lookup was not? For future reference.

[Haseeb Avarakkan]

You can't use LOOKUP that way, since you only have two rows, use HLLOKUP instead.

=HLOOKUP(TEXT($E$1,"mmm"),'Metric Scores'!$C$4:$N$5,2,0)