Excel 2003 find function help/issue!

[controlfreak]

Hi guys,

Love the forum, it rocks!

Just wondering if someone could help me out. Just doing a bit of database performance qualification. Basically i have two worksheets. Old and new. Both have a large range of titles and corresponding values. This is a document database so i will be searching/sorting by the range i call DocumentID. Now the new worksheet was created by taking 500 random rows from the old. What i need to do is for every DocumentID entry in the new sheet i need Excel to scan the old worksheet for the same ID and return the entire row that ID is on. Into a third worksheet perhaps?

Hope I'm explaining this ok!

Anyway is this possible? Do i use the "FIND" function?

Thanks guys for any help you can give me!

[oldchippy]

Hi,

Welcome to the forum, take a look at this link on VLOOKUP

http://www.contextures.on.ca/xlFunctions02.html