Vlookup help

[Guest]

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

 

[Guest]

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.

 

[Guest]

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

 

[idrake]

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

 

[Guest]

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

 

[Guest]

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