Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
VLOOKUP
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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
VLookup a Vlookup | Excel Worksheet Functions | |||
VLOOKUP Problem | Excel Discussion (Misc queries) | |||
VLOOKUP Limitations | Excel Worksheet Functions | |||
Have Vlookup return a Value of 0 instead of #N/A | Excel Worksheet Functions | |||
vlookup data hidden within worksheet | Excel Worksheet Functions |