VLOOKUP help

[Guest]

Hi,

How do I setup VLOOKUP so that it looks up the 1st three letter of the cell
in a column, then put other information in other column on the corresponding
row.
Data sample:
Worksheet 1 Worksheet 2
A A B C (column)

1 1AB-005 1AB 114 A
2 2ER-515 4BR 115 B
3 4BR-006 2ER 116 C

VLOOKUP(A1, worksheet2!A1:C3, 2, FALSE)

Lookup worksheet 1 2ER####, if the frist 3 letter match column A in
worksheet 2, then return the corresponding row that matches in column B = 116.

Thanks for any tips

 

[Guest]

Try this:

=VLOOKUP(LEFT(A1,3),worksheet2!A1:C3,2,FALSE)

HTH,
Elkar

 

[Guest]

one easy way is to use:
vlookup(left(A1,3)
this would look up the left three characters
this assumes that the left three characters would be unique