Can someone help with a small macro? Search for Text and copy Text from cells

Hi,

I am a beginner in using VBA with Excel. I have written some Macros with different functions but now I could use some help....

What do I want?

I have two worksheets "overview" and "listing". "listing" is full of information material.

In the overview sheet are Numbers in column A (i.e. A1 = 10 ; A2 = 12 ....).

Now my VBA Script has to look into column A and than search for the number it did find there in sheet "listing" (these numbers are always and only in column C in this sheet). If the script finds the number (which is btw unique) the programm has to look 5 cells to the right and copy the text to sheet "overview" into B1.

Before you guys try to invest a lot of time a small hint on how to realise the function " find the value from A* and go 5 cells to the right in the same row and copy the content" could be enough help.

Thank you very much!!!

André

Andre:

I think a VLOOK-UP formula could be helpful. Could you attach a sample file with your layouts. You can just use some dummy data and explain. To attach a file, click on Go Advanced, scroll down to the Manage Attachments button, browse to the required file, and then push the Upload button.

Hey,

thank you for your help. I think the easiest way to show what I want is to create a minimal working example because my Excel sheet is full with thousands of datasets with complex calculations.

I have written down a comment in this document. I hope you get what I mean.

Thank you very much! I appreciate your help a lot.

Greetings
André

MinimalWorkingExample_001.xlsx

Copy this formula on Sheets overview From C4 to C17 to see if it does what you want.

=IF(ISNA(VLOOKUP(A4,listings!$A$2:$P$219,16,FALSE)),"",VLOOKUP(A4,listings!$A$2:$P$219,16,FALSE))

Hey,

I cannot insert this formula. I get en error. Excel says that there is a mistake in this formula and I dont get it.

Hmmm ...

Ok now I get this.... I am using the german version. I only translated the functions but did forget that the seperators differ from the english version ";" instead of ",".

Now its working.

Thank you very much for your nice help!

André

You're welcome. Glad to help out and thanks for the feedback. Please comply with the Forum Rules and mark this thread as solved.

http://www.excelforum.com/forum-rule...rum-rules.html