ok how do i use this to match values in one column to values in another? if not by this means, then how do I do that?
oh great, thanks also for replying....
well....column A has codes, Column B describes what these codes are, Column C are other codes some identical to those in column A. I want column D to have the description of the codes that are already known based on Column A and B. Does this make sense? I don't want to have to manually do it as there are hundreds........
i want excel to look at column A to see if the code in Column A matches the code in Column C then the associated description in Column B to be in column A. I am sure there is a way, but it is complicated...
no column D
yes you got it. i am using excel 2010. here is the file....
Here you go:
you are taking way too long. if you don't know how to do it just say so, but keeping me suspended like this is not that nice. i need a quicker answer as it is for something urgent.
Have you tried VLOOKUP? In this specific requirements of yours requires a VLOOKUP function in order to automatically enter the description if there is a "match" with the code.
However, if there is no match, NA is entered to the cell and you can then manually enter the description if that description is NOT in the table of descriptions.
Here is the modified file:
Now, in that file, please note that I have placed a sample lookup table. Enter the code and see how the sample description changes as you enter the correct code. If the code is NOT in the table, NA is displayed.
Now, regarding the formula or how to do the vlookup, please do this:
Please be sure to rate my answer with 3 or more stars/faces if this helped. Keep me posted with your results so that I can help you further. If you have further question, please reply to me so that I can help you further.
There is no file in the link you sent me. I get an blubberish xlm file. Please fix so I can rate.
Nevermind. on second look it worked.........
i am trying it on another file it's not working. here is the link: I am trying to do it for the same column as before.
Please answer asap as I have to have results by this morning
Thanks a lot, I look forward to give you plenty of excellent feedback. Let me know if you think I should post this as a new question, but could you tell me:
1. how to add 1 zero before every two digit number in the column and 2 zeroes for every 1 digit number. The minimum no of digits should be three. Not also there are some values with a preceding letter. Nevertheless, I also want to fix those numbers in this way.
2. Once I do this, I want like to add a decimal point to each number (or letter-number) in a way that it is the decimal is in the second place, e.g.
100 to 10.0 and 010 to 01.0
Attached is the column in question. I will rate all aforementioned answers seperately so don't worry.
Yes, exactly. i was able to add the zeroes, but it is the decimals that is difficult. Eventually, I will remove the decimals, but before that I have to put so that the numbers can end up in the format that is appropriate.
See if this is what you're looking for
precisely....but can you tell me how to do it since this will not be the first time i will need to do this
Sure, one moment please...
Here you go.
The formulas are in columns B and C
Hope this is ok. Let me know if you have any questions
this file is what i meant...
You're right. My bad!
Here, please check this one and let me know if it needs anything else
Still not quite right. As you recall, i needed the decimal after the second digit, not the first....
Ok, here is the decimal after second digit
Let me know if you have any questions
this is great, but why when ever I copy and paste the column it starts to give me two decimals? may be the reason is i don't understand the program. could you explain it to me...
There are two columns with formulas which are dependent on each other, so you have to copy both and know where to paste them. If you are not sure I suggest keeping the formulas where they are and paste the new data in column A instead
Hope this makes it clear and brings this issue to conclusion
Hi, i found a mistake in this file, but it's not your fault at all. Those numbers with only two digits should be considered as 93.0
Thus, 56 should be 56.0
48 , 48.0
we previously made it as 5.6, 4.8 because we added a leading zero, which was not right.........
can you fix it? here is the link..........http://wikisend.com/download/247446/Copy_of_srgcd2b.xlsx
I'm a bit confused. Are we working with two files and two different issues?
yes, two files, slightly different issues
Ok here you go
Again, I did away with the first formula column since it is no more needed with this new requirement. I also allowed for up to 5 digit numbers
Hope this helps
I rated you excellent because you did what I asked you, though for me, it has not solved the problem since the programmers at my workplace have given me wrong information. Looks like we'll have to figure this out on our own, for now.
Could you tell me: in this series of right justified numbers, where would the decimal place go?
Please note, as before, if the numbers are two we add one leading zero and if one, we add two leading zeroes.
Ok will look into your last remarks
In the meantime you have not rated the main question, so could you please do so if the solution is as per your request. Here is the link
Ok I checked your last message but you need to give me the requirement so I can give you the solution. Specifically please show me how you need to have the above 5 codes formatted and I will be happy to provide the formulas which you will be able to apply to all the list. If in doubt I suggest that you ask the proponent or your workplace how they want these 5 codes formatted to make sure that the solution will per their advice
as before, but easier.
decimal alwaysafter the third character/digit. Leading zeroes have already been added so that is irrelevent