Assuming you have your data to lookup in Book1.xls in Sheet1 Col A & B
then enter this in A2 in the other one;
=VLOOKUP(A1,'[Book1.xls]Sheet1'!$A:$B,2,FALSE)

An easier way is to enter the formula upto =VLOOKUP(A1, and then click on
the other workbook, select cols A & B then enter the rest of the formula i.e.
enter ,2,False)

"Carla" wrote:

Hello,
I'd like some help with the lookup formula you would use to reference cells
across different worksheets. For example, if a certain word is typed into
cell A1, then I would like cell A2 to reflect a value that appears on another
worksheet (if the word changes, then the worksheet reference changes). I
have tried LOOKUP(A1,{x,x},{x,x}) and basic IF formulas.
Hope someone can assist, if more information is needed, let me know.
Thanks
--
Carla