VLookup - Not Exact Match
 

I'm using VLookup to find a similar value because the exact match isn't
available. I know that if you put "True" in the formula it will find the
next value, but my problem is, is that the next closest match has a letter.
How can I make it find the value plus the letter. Example: I'm trying to
find 2200218 but the closest match is 2200218A. This is the value I want it
to find, not 2200217 or 2200218.

VLookup - Not Exact Match
 

With your lookup value in C1 and your data in columns A:B...

=VLOOKUP(C1 & "A",A:B,2,0)

This finds the exact match adding the letter "A" to the end of the lookup
value.
I'm not sure if that's what you want since this formula will always add the
"A" to the end.

Good luck,
Paul


"vmagal1" wrote in message
...
I'm using VLookup to find a similar value because the exact match isn't
available. I know that if you put "True" in the formula it will find the
next value, but my problem is, is that the next closest match has a
letter.
How can I make it find the value plus the letter. Example: I'm trying to
find 2200218 but the closest match is 2200218A. This is the value I want
it
to find, not 2200217 or 2200218.

VLookup - Not Exact Match
 

=VLOOKUP(C1 & "A",A:B,2,0)

Perhaps try also:
=VLOOKUP(C1&"*",A:B,2,0)
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---