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))