vlookup first 4 characters only in a column

[Guest]

Hi

Any help with the following would be greatly appreciated -
I'm trying to do a vlookup whereby it only searches/has to match the first 4
characters in the utmost left column of the table and return the associated
cell. My non working formula is:

=VLOOKUP(A:A(left4),EmailList!A:C,3,FALSE)
whereby the A:A(left4) is meant to be the first 4 characters from the left
of the column.

Thks
Gus

 

[RagDyeR]

Try this:

=VLOOKUP(LEFT(A1,4),EmailList!A:C,3,FALSE)

--

HTH,

RD
==============================================
Please keep all correspondence within the Group, so all may benefit!
==============================================



Hi

Any help with the following would be greatly appreciated -
I'm trying to do a vlookup whereby it only searches/has to match the first 4
characters in the utmost left column of the table and return the associated
cell. My non working formula is:

=VLOOKUP(A:A(left4),EmailList!A:C,3,FALSE)
whereby the A:A(left4) is meant to be the first 4 characters from the left
of the column.

Thks
Gus

 

[Domenic]

Try the following...

=VLOOKUP(A1,LEFT(EmailList!A1:C100,4),3,0)

....confirmed with CONTROL+SHIFT+ENTER, not just ENTER, and where A1
contains your lookup value.

Hope this helps!

 

[RagDyeR]

If Column A contains numbers, try:

=VLOOKUP(--LEFT(A1,4),EmailList!A:C,3,FALSE)
--

HTH,

RD
==============================================
Please keep all correspondence within the Group, so all may benefit!
==============================================


Try this:

=VLOOKUP(LEFT(A1,4),EmailList!A:C,3,FALSE)

--

HTH,

RD
==============================================
Please keep all correspondence within the Group, so all may benefit!
==============================================



Hi

Any help with the following would be greatly appreciated -
I'm trying to do a vlookup whereby it only searches/has to match the first 4
characters in the utmost left column of the table and return the associated
cell. My non working formula is:

=VLOOKUP(A:A(left4),EmailList!A:C,3,FALSE)
whereby the A:A(left4) is meant to be the first 4 characters from the left
of the column.

Thks
Gus

 

[Guest]

Hi Domenic

The formula below returned the #N/A value but a manual calculation should
have returned the value 2?

Rgds
Gus

 

[Myrna Larson]

Try it this way:

=VLOOKUP(LEFT(A1,4)&"*",EmailList!A1:C100,3,0)

This is a "regular" formula, entered with just ENTER, not an array formula.

 

[Guest]

Thank you to all who replied and helped on this matter!