Thank you, John!! That works superbly! Have a great day!! Connie

"John Bundy" wrote:

You can change the range as needed but here is what I did, i named the 3
columns you gave in your example Salestype and entered this formula:
=LEFT(VLOOKUP(L1436,Salestype,3,0),FIND(" ",VLOOKUP(L1436,Salestype,3,0))-1)
This used 100009421 as the test and returned B650TBG

you can change salestype to whatever you want but the first column must
contain the number i.e. 100009421. That being column 1 of your range count
over to the one with your item number, if it is not column 3 then replave the
two 3's in the formula with the correct column number.
--
-John
Please rate when your question is answered to help us and others know what
is helpful.


"Connie Martin" wrote:

Okay, this is to both John and Kostis. I used the "LEFT" part of your
formula, Kostis, and I deleted the name SALESTYPE and redefined the named
range DLVYTIME to include all columns, and then I put this formula in N1436,
which partly works:
=LEFT(VLOOKUP($L1436,DLVYTIME,3,FALSE))
What it's doing is putting only the first letter in, which is "B". How do I
get it to return everything up to the first space, which would be B650TBG?

This is getting exciting.....we're on to it, just not quite all there!

Connie Martin


"Connie Martin" wrote:

Hopefully, I can explain without too much complexity!

The worksheet that has the columns of data that I want to look up has 4
columns of data. In the 3rd column the data varies widely, but here's a
general example:
B650TBG CB 325X400 STD SET

In another worksheet (of the same workbook), I need a formula, which is
going to start in cell N1436, that will go look up the data in this 3rd
column, which I have named SALESTYPE, and will put in the cell N1436 only the
combination of letters and numbers up to the first space---in this case
B650TBG. This is not consistent, however. The first space could be after
just three digits, as in this example: C91 W 8.875 X6.750 X1.625, in
which case it would only put C91 in cell N1436.

Hope this can be done. Thank you. Connie Martin