"Advanced" search and auto-copy

[sadhammer]

Greetings.

I am new to this forum and not very skilled with excel formulas. I hope someone can help with this potentially stupid question:

Let's say I have one excel sheet with a single, essentially random number in one cell. Is there a way to write a simple formula that can search for an identical cell in another, specific sheet or document and, if found, copy the entire row with that identical cell in the second sheet/document into the first sheet, preferrably right next to original cell? If it helps, the "random" number will appear at most only once in the second sheet/document, but may not appear at all.

Thank you for your help.

[FDibbins]

you could use a match() or vlookup() to 1st search for the number in the other sheet, and then use vlookup to return the rest of the data.

if you provide a sample i can get something started for you?