Matching numbers and text
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)
|