LOOKUPS

Hello Teresa

Thank you for your question and welcome to the forum.

If you are using a vlookup, for example, the structure of the function is exactly the same regardless of whether the vlookup is returning data that is stored on the same sheet as the formula, a different sheet in the same file, or from a different workbook altogether.

i.e. =vlookup(lookup_value,table_array,col_index_num,range)

If you are creating a vlookup which returns data from another workbook, then you will need to be aware that a link will be created between the two workbooks.

The implication of this is that if the workbook containing the table of data (table_array part of the vlookup formula) is either moved to another location on your computer or network; or if this file is renamed, then you will need to re-establish the link between the two files for the lookup to work.

I hope this helps.
Amanda