Did you try it?

This worked for me
=VLOOKUP(LEFT(A1,3)&"2xxx",Sheet2!A1:B10,2,FALSE)
As did
=VLOOKUP(LEFT(A1,3)&J1&"xxx",Sheet2!A1:B10,2,FALSE )
with value of 2 in J1

best wishes
--
Bernard V Liengme
Microsoft Excel MVP
http://people.stfx.ca/bliengme
remove caps from email

"Himansu" wrote in message
...

Morning everyone,

Is it possible to use vlookup by trimming values in a column. It's a
little
hard to explain, but here's an example:


Worksheet 1:

column1 column2
--------- ---------
hha1xxx "matched value from worksheet 2"

--------------------------------------------------------------------------
Worksheet 2:
colum1 column2
--------- ---------
hha2xxx 845


---------------------
I want to match by hha2xxx by extracting "hha"&2&"xxx" in worksheet1. Is
this possible? Here's what the result should be:

Worksheet 1:

column1 column2
--------- ---------
hha1xxx 845


** Please advise.

--
Thanks,
Himansu