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