OK, having looked at your formula again, the only problem I see is that you
need ",0" between your closing parenthesis. Syntax is
VLOOKUP(what,range,offset,FALSE(or 0)). You left out the FALSE part, and
there fore you are not getting an exact match

--
Hth

Kassie Kasselman
Change xxx to hotmail


"David T" wrote:

Hey Cassie-

I didn't realize that both of my examples were 16 characters long. Oops! I
need a VLOOKUP formula that will lookup the values after the year no matter
how long the length of characters are. For example:

September 2007 Transport
October 2007 PAL Balancing Fee
December 2006 Demand Charge

Thanks!!

"Kassie" wrote:

Info is a bit limited, but try the following

=VLOOKUP(RIGHT(C27,16)'By Counterparty'!$J$1:$K$3,2)

It so happens that both "Transport charge" and "Commodity charge" is 16
characters long.

--
Hth

Kassie Kasselman
Change xxx to hotmail


"David T" wrote:

I need a Vlookup formula that will ignore everything to the left of the year
"2007" and only lookup the values "Transport charge" or "Commodity Charge".
My current formula is not pulling the right data. Please Help!


October 2007 Transport charge ' I need to look up the word "transport
charge" and
Sept 2007 Commodity Charge ' "commodity charge" below

Current Formula
=VLOOKUP(RIGHT($C27,LEN($C27)-FIND("2007",$C27)-4),'By
Counterparty'!$J$1:$K$3,2))