Need help on cell format

[BB]

I have a column shown part no. starting ST then dash with part no. after. I
can't vlookup the qty from the part no. column from other worksheet, however
if I re-type the same part no. each cell in the column, I would able to
lookup these part no. and find qty.

Is there an easy way to copy format instead of re-typing each part no. again
in
the cell? Please help...

Thank you,

 

[Toppers]

Does this help?

D1 contains ST-1234

A1:B20 is the part no/qty table and am assuming it contains 1234 etc

=VLOOKUP(MID(D1,4,255),A1:B20,2,FALSE)

 

[Dave Peterson]

You have a reply at your first post.

I have a column shown part no. starting ST then dash with part no. after. I
can't vlookup the qty from the part no. column from other worksheet, however
if I re-type the same part no. each cell in the column, I would able to
lookup these part no. and find qty.

Is there an easy way to copy format instead of re-typing each part no. again
in
the cell? Please help...

Thank you,

 

[Toppers]

See Dave's reply as I misunderstood your problem!