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

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

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

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

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

Hello all-

Thanks for your help, but after taking a look at my spreadsheet, I realize
that too many of my lookup reference values are similar, that is why vlookup
is not able to pull the correct vlookup values from the array. for example,
the lookup up values below are too similar because all of the ending values
end with "Commodity"

October 2007 NUI_ETG Commodity
October 2007 SEM Commdity
October 2007 _VNG_SEQ Commodity

I think what i need to do is to recreate lookup values that will not
conflict with one another. Thanks for your help
"Kassie" wrote:

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