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