View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
mndpy mndpy is offline
external usenet poster
 
Posts: 24
Default 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)