Vlookup question

[flowtime]

Alright I am running a business and we are ecommerce based. We take order off the internet and then package them (assembly line style) in boxes.

When we get orders off the website it comes in this format

6 - item x
2 - item y
7 - item z

etc...

and in my warehouse i have the items in certain pick spots with the columns going from 1-60 and the rows going A-C... example

item x is in 5A
item y is in 28B
item z is in 40C

I need help on how to get excel to match up
"6 - item x" to "5a"
"2 - item y" to "28B"
"7 - item z" to "40C"

I am using MS excel 03 or 07 which is ever is better to make it work. Please advise as quickly as possible because we are taking orders now and I am trying to do all these manually Thaks in advance for any help

[rylo]

Hi

Using your example, put the value pairs item x,5A; item y,28B; item z,40C in the range A1:B3.

Put your data in the range A6:A8 (ie 6 - item x).

In B6 enter the formula
=VLOOKUP(RIGHT(A6,LEN(A6)-SEARCH("- ",A6)-1),$A$1:$B$3,2,FALSE)

Copy down to B8.


rylo