Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Vlookup: Have problem. Not taking the object that i search...
Hi.
I have part codes in my A column. For example 10 parts in first column. And i have all part codes in column D and have all prices for all codes in column E I want to take the prices for that 10 parts and so use the vlookup. But the codes are not in same style. I mean in A they are as; 2G15 2144 2111 2G15 2144 2111 In first code, there is only one spece and in second there are 2. My first question; TRIM is used to clear the speces in front and back of of the sentence. I want to clear all spaces in the column (not with find and replace :)) So how can i? And i have the main question; When i use the vlook function; 2t14a500td can take the value of 2t14b500td or like it. But i want it to take the value of 2t14a500td Why? How can i give the correct number? |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Vlookup: Have problem. Not taking the object that i search...
The first part is done with SUBSTITUTE
=SUBSTITUTE(A1," ","") which you can use in another function. -- HTH RP (remove nothere from the email address if mailing direct) "SupperDuck" wrote in message ... Hi. I have part codes in my A column. For example 10 parts in first column. And i have all part codes in column D and have all prices for all codes in column E I want to take the prices for that 10 parts and so use the vlookup. But the codes are not in same style. I mean in A they are as; 2G15 2144 2111 2G15 2144 2111 In first code, there is only one spece and in second there are 2. My first question; TRIM is used to clear the speces in front and back of of the sentence. I want to clear all spaces in the column (not with find and replace :)) So how can i? And i have the main question; When i use the vlook function; 2t14a500td can take the value of 2t14b500td or like it. But i want it to take the value of 2t14a500td Why? How can i give the correct number? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
vlookup problem, possibly due to "noise" | Excel Worksheet Functions | |||
VLOOKUP Problem (limitation)? | Excel Worksheet Functions | |||
VBA: Where to find Excel Object model? | Excel Discussion (Misc queries) | |||
VLOOKUP problem | Excel Worksheet Functions | |||
Problem with search | Excel Worksheet Functions |