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? |
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? |
All times are GMT +1. The time now is 01:44 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com