Search results

Hello Luke, Let me clarify on what you say, If I have a discontinuous ranges as c1 c3 c4 and this range contains formulas. If I would copy this range, can't I paste the range to c1 c3 c4? I think we can, please advise me. Regards, GN0001

I did a bunch of VLookUps, they are all working, however among the returned values, I saw that one returned value is wrong. What is the reason? I didn't have any duplications on my list. The data type for look up range and look up item was the same. Any suggestion. Thank you very much. GN0001

I have to lists in two sheets: Sheet A Sheet B In Sheet A, I have employee Number In Sheet B, I have employee Number I want to find out what employees are in Sheet A but they are not Sheet B and vice versa, What method do we need to use? Regards, GN0001

This can not be done as you describe. You will need to first sort your data, then filter, then copy and paste. May I ask why? We filter and the I need to paste only on the filtered values which are non-adjacent cells. How could it be related to Hello Luke Are you saying that we can't paste...

I have run into another issue, in doing VLookUp, I want to post it in a different thread. Thanks, GN0001

Fine, I understood. I wanted a verification from an Excel Ninja. G0001

Somendra, Fine, I understand it. Then what is the reason when it finds the value in sheet a, it places the value in b2 in sheet 1, why does it not place it in sheet 1 in b3? Please advise me. GN0001

I don't want to use an if here. I am going to dig into VLookUp. What you have on the top is totally different from what I mean. I am looking for a value in sheet b in a range in sheet a. You have changed the function. Sorry about it. Thanks GN0001

Yes, this is right, as I said before, it brings back the value, but it doesn't bring it back in a right place.

I am looking sheet 2 value in sheet 1. =VLOOKUP(Sheet2!$A2,Sheet1!A:A,1,FALSE) This is what I want. I never asked for =VLOOKUP(A2,Sheet2!A:A,1,) This is a big issue for me. Why VLookUp behaves like this? Thanks, GN0001

I put filter on a column Then copy the cells and I want to paste the values on the same range from which I have made my copy from (to paste on non-adjacent cells), it doesn't work. It says the copy and paste area should be the same. I posted a question, a team member replied to my question...

Naryan, I put your code in my own file. File is uploaded. As far as I tested, it worked. However I want: 1- To enter character a, it has to show all the strings that start with a, not all the strings that contain a. 2-How can I put a password on the code, that nobody can see the code. I...

I do a VLookUp, please see uploaded file. VLookUp picks up the value, but it doesn't show the picked value in a right cell. Value 346263 is picked, It has to be shown in column b in front of value 346263 in column a, but it is being shown in front of 351919. Please see the uploaded file. What...

Thank you for the guidance. GN0001

Naryan, I think this is what I want. thank you I get back to you. Please use my name as GN Or GN0001 for job purposese. Thanks, GN0001

I already sorted the column and it worked for me. So I don't have it, but I try to go back to start position when I was experiencing the issue. GN0001

But I want to find out the reason why VLookUp acting as this, instead or replacing with another function. Thanks, GN0001

Hi GN0001, You must have selected TRUE as your fourth argument of VLOOKUP(), which does an approximate match which works on sorted table. For unsorted table use FALSE or 0 for an exact match. Regards Hi, I had False and I am sure about it. GN0001

------------------------------------------------------------ Narayan, No, I entered my function as: VLOOKUP(lookup value , lookup range , column number , FALSE) I am sure about it, but it brought me back the list from bottom to top. very strange.

I am going to format my cell. It doesn't allow me, it says: too many cell formats I try to clear up format, still it doesn't work. How to solve this issue? Regards, GN0001

Please address this issue. GN0001

I did a VLookUp at work today. it picks up the value from the bottom of the list for the first look up value. What is the reason? I sorted, it did work properly, but I need to know what is the issue when it is not sorted. it doesn't pick up value. Do we always need to sort the the look up list...

You can move the ComboBox to another sheet.. and re-create the same code for the comboBox. Please check the attched.. Now seach Box has been moved to another sheet. :) Hello Manish, Thank you for your response. it doesn't work at all. I entered strings from your own list and pressed enter...

Can you please modify this code and put the list in a different sheet? Thanks, GN0001