No such luck...any other ideas let me know. I appreciate it! Thanks!!!

"fair_thumb" wrote:

maybe this give a trick on the match formula with index function.

the cell 'F Codes'!G7 maybe was formatted as text,
try to change and use format as general on the said cell.

Regards



"mndpy" wrote:

I have on spreadsheet that has a column with a list of single numbers or
letters the next column are times associated with those numbers and letters.
I want to type in one of those numbers or letters and have it displayed in
another worksheet the time associted with it. I have it half working that is
displays the letters but is comes up with a #N/A when you type in a number to
match. Here is what I am using. Any help would be appreciated!

=INDEX(Codes!$A$2:$B$33,MATCH('F Codes'!G7,Codes!$A$2:$A$33,FALSE),2)