VLOOKUP to transfer data

Hi Julie,

Thank you for your question and welcome the forum.

Use Insert and then function to bring up the function dialogue box. You will find the function in the lookup and reference category.

The first argument is the cell that contains the lookup value. The second argument is the range of cells in the other workbook you are trying to retrieve the data from. The third argument is the column number from the data set for the desired field value to be returned.

http://www.contextures.com/xlfunctions02.html

http://pubs.logicalexpressions.com/pub0009/LPMArticle.asp?ID=446

I hope this answers your question.

Regards

Simon