View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.worksheet.functions
mndpy mndpy is offline
external usenet poster
 
Posts: 24
Default Matching numbers and text

That works but only for the letters I'm looking for. It still doesn't like
looking for the #'s. Any idea on how to search both?

"Toppers" wrote:

Try:

=VLOOKUP('F Codes'!G7,Codes!$A$2:$B$332,0)

"mndpy" wrote:

What lookup should I try?

"Bernard Liengme" wrote:

Suggest you do a test to check if the numbers are actually text.
In a cell in F Codes sheet enter =G7=Codes!A12 (replace A12 by a cell that
has a number). Type the same number into G7 as you see in Codes!A12; you
should get TRUE as the result.
Or on Codes sheet in D2 (or wherever) use =ISNUMBER(A2) and copy down to
D33

But why not use VLOOKUP?
best wishes

--
Bernard V Liengme
Microsoft Excel MVP
www.stfx.ca/people/bliengme
remove caps from email

"mndpy" wrote in message
...
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)