I have two separate workbooks. In one workbook there is a code with no
description. In the other, the code includes the description in the next
column. My user wants to insert a formula in Book 1 that will look up the
correct description from Book 2.
Example - Book One
Employee Code Description
101
200
319
101
101
319
Book Two
Employee Code Description
200 Math Teacher
101 Science Teacher
319 Custodian
Does anybody have any idea what kind of formula I use and how to write it? I
want to be able to put a formula in the Description field in Book one that
will find the correct value ANYWHERE in Book 2 (101, 319, etc), then
reference the description and place it in the Description field in Book 1.
Sherry
Bookmarks