View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Pete
 
Posts: n/a
Default VLOOKUP (with text)

You can use text as the lookup value.

You probably want to get an exact match, so set the fourth argument
within the VLOOKUP function to FALSE or 0. You might also need to use
the TRIM( ) function so as to avoid any trailing spaces. You may
actually be returning blank values - check your range and the column
within that from which you want to return the values.

Hope this helps.

Pete