Thread: Vlookup help
View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.misc
[email protected] idrake@performics.com is offline
external usenet poster
 
Posts: 1
Default Vlookup help

Hi David,

You do not need to vlookup use this formula: =RIGHT(A1,LEN(A1)-
(FIND("2007",A1,1)+4)). A1 is equal to "December 2006 Demand Charge"
without quotes. That should give you the right charge that you need.

Salut!
Isiah