Vlookup:My appologies

[jagadesh_gn]

Hi all,

I have a data in column A sheet1, column A sheet2, i need a vlookup macro and compare the sheet and the result should be displayed in sheet3. can anyone help me on this.

[teylyn]

Hello,

why do you think you need a macro? Why do you think you need a Vlookup?

This can possibly be done without any VBA and without any Vlookup formula involved.

What do you want to display on sheet 3 exactly? Please post a workbook that shows data in Sheet 1, data in Sheet 2 and the expected result in Sheet 3.

Without these premises, anything we can provide will be guesswork. You need to define the specifications in more detail.

cheers,

[jagadesh_gn]

hey, i need this to run a shell script which will pick up this data..

[jagadesh_gn]

Hi i need the vlookup results to be placed in sheet3

[teylyn]

1. Not enough information about the expected results. I don't know what you want to see and you have not shared it.

compare the sheet and the result should be displayed in sheet3.

You have not described what the result of the comparison should be. "TRUE" or "FALSE" if the lookup matches/does not match? "YES" or "NO" ? The value? No value if there is no match? Or an error message? A rollup of all matches with no blank rows in between? What?

I'm sure that in your head you have a picture of what you would like to see as the result, but so far you have not managed to describe it to this forum.

2. "shell script" -- can you elaborate? There's more than one shell. Which one are you using? This forum focuses on Excel topics, not operating systems.

[jagadesh_gn]

Hi, i have attached an excel sheet which contain the data in sheet1 and sheet2 also i have writen a vlookup in sheet3 (=VLOOKUP(Sheet1!A:A,Sheet2!A:A,1,0)), by comparing the values of sheet2 with sheet1.
now i would need the same to be written in VBA macro, can some one help on this.

[teylyn]

1: The vlookup formula you are using in your Sheet3 is not correct. Hence all the results are error messages.

Vlookup only takes an individual value as the first argument, not a range, as in your formula.

It is still not clear what you want to compare with what. Can you please put that into simple words instead of a formula that does not work? What do you want to compare with what? What shoudl the resulting cell show? Please mock up a spreadsheet that shows the result (entered manually), not a formula that throws an error.

2: VBA is not a shell script. I'm not really sure that you know what you actually want. Please clarify.

[jagadesh_gn]

Hi teylyn,

Let me describe more.
I have some data in sheet1 and some data in sheet2. I want to see if the values in sheet2 is present in sheet1 and print them in sheet 3 if present. I dont know how to do it. This has to be done repeatedly and would be happy if i get a macro for this, so that i can just run the macro whenever i need to do the comaprison.
I have attached the sample file for your reference.

Thanks in advance for the help...:-)

Regards,
Jack

[jagadesh_gn]

Hi teylyn,

Let me describe more.
I have some data in sheet1 and some data in sheet2. I want to see if the values in sheet2 is present in sheet1 and print them in sheet 3 if present. I dont know how to do it. This has to be done repeatedly and would be happy if i get a macro for this, so that i can just run the macro whenever i need to do the comaprison.
I have attached the sample file for your reference.

Thanks in advance for the help...:-)

Regards,
Jack

[jagadesh_gn]

Hi All,

Let me describe more.
I have some data in sheet1 and some data in sheet2. I want to see if the values in sheet2 is present in sheet1 and print them in sheet 3 if present. I dont know how to do it. This has to be done repeatedly and would be happy if i get a macro for this, so that i can just run the macro whenever i need to do the comaprison.
I have attached the sample file for your reference.

Thanks in advance for the help...:-)

Regards,
Jack

[teylyn]

Is there any particular reason that you repeated your last post several times over several hours? At first I thought it was a fault with the forum software, but then I realised that you posted the exact same message three times, several hours apart. What do you want to achieve with that? Please be aware that everbody here is a volunteer. We have jobs, we have families, and we may live in a time zone that differs from yours, so we may actually not be on-line during your waking hours.

The spreadsheet you attached shows content in the first two sheets. You still have not explained or mocked up what you would like to see as the result. It is really hard to guess what you want to see. It would be much easier to suggest a solution if you could show an example of what you want to achieve.

So, if you expect members here to spend their own free time on solving your problem, please make it as easy as possible for us to understand what you want to achieve.

[jagadesh_gn]

Thx, for your advice. i have better way to find the solution for this. I am feeling sad that i am part of such a good for nothing forum. if you dont know tell exactly dont know dont bluf or act if u know everything....that too such a simple language i have explained u.....

[teylyn]

In my first comment to your question I have politely asked you

Please post a workbook that shows data in Sheet 1, data in Sheet 2 and the expected result in Sheet 3.

You still have not done that. I don't know what you want to see as the result. I keep asking, but you have not given an example of the expected result.

If the comparison of the cells is false, what should Sheet3 show? An empty cell? Or should there not be any empty rows? An error message? Or do you not want any error messages? And so on, and so on.

It's easy to compare data. But there are many different ways to present the results. So instead of getting all huffy, you could try to do what was suggested in the first comment and describe your expected output. An example would be best.

Unless you show me what you want to see as the result, I cannot start to put together a solution.

cheers,

[jagadesh_gn]

Sheet 3 should contain only the matching values in sheet 1 and sheet2...If both the sheet values doesnt match we can simply ignore...No need to display any error mesasage...simply put, do nothing if it doesnt match and print in sheet3 the matched value....

[teylyn]

I don't know what's so hard about posting an example of your expected results. Even after you insulted me, I'm still willing to help you. But please answer my questions. I'm asking them for a reason.

thanks

[jagadesh_gn]

My appologies if you hurted.
Find my attachement for the Results in sheet3, i would expecting a results in that format. Please let me know for further details.

[teylyn]

Sorry, but that does not make much sense.

Your explanations list values that are present in both sheets, values that are only present in Sheet1 and values that are only present in Sheet2.

I need to know what you expect Sheet3 to look like.

Given that you want to compare each value in Sheet2 with the values in Sheet1: What will be in the first row of Sheet3? What will be in the second row? What will be in the third row?

Your explanations seem to contradict each other.

compare the sheet and the result should be displayed in sheet3.

I want to see if the values in sheet2 is present in sheet1 and print them in sheet 3 if present.

Sheet 3 should contain only the matching values in sheet 1 and sheet2...If both the sheet values doesnt match we can simply ignore..

and in the last upload of the spreadsheet you list values in sheet 3 for each of the three cases

1. Find the below value present in sheet2 and in Sheet1
2. The below value present in sheet2 but not in Sheet1
3. The below value present in Sheet1 but not in Sheet2

I honestly do not know what you want to see as the result.

Can you please mock up (that is: manually enter) on Sheet3 exactly what you would want to see as the result of a formula or macro.

I think I have made it overly clear that I'm trying to help you. I don't know how else to ask you for an example of the output you want to see.

[jagadesh_gn]

Hi give me only this result
1. Find the below value present in sheet2 and in Sheet1
the sheet3 value should have the data which is present in sheet1 and sheet2, that is enough.

[teylyn]

Sorry, I don't seem to make myself understood.

If a match is found, then show the match. Fine.

If no match is found, then what should the cell show?

I find it unbelievable that you will not take the little effort to mock up an example of your expected output.

Frankly, I'm losing interest in this question. It's you who should be willingly give the explanation. Not me asking again and again for it.

[jagadesh_gn]

can you please assign this question to some one else, even i am loosing hope on this sight...please share this question to some one else who can help me.
I am really fedup of explaining the question, still now i did not get any useful answer or even sigle code for this...just simply i have wasted my time.

[teylyn]

This formula in A1 of sheet 3 will return values from Sheet2 that are present in Sheet1

=IF(ISNA(MATCH(Sheet2!A9,Sheet1!A:A,0)),"",Sheet2!A9)

copy down as many rows as there are rows in Sheet2.

If the value in Sheet2 is not found in Sheet1, the cell will remain blank.

So far, you have not described what you want on Sheet3 if there is no match. It has been a challenge to follow your descriptions.

[abousetta]

@jagadesh_gn you need to take a step back, take a deep breath and think about what you want exactly. From the previous posts teylyn has been more than generous with her time and effort to try and explain what vlookup and try to decipher what you want. teylyn has more posts on this forum than almost anyone else. That means that she has helped countless individuals. Don't you find odd that she can't understand what you want?

Do you actually know what you want? If so, then create a small mock excel sheet to show us. Either that or pay for a consultant to go through a long process of trial and error until they figure out what you want. Of course since they are paid per hour, I am sure they won't mind.

abousetta