I'm still confused and probably wasn't clear enough on what I'm trying to do.

This is actually in two separate workbooks, not worksheets.

Basically, here is a better run-down:

If the value in cell A1 in Book 1 is found in ANY cell in Book 2, then
return the value of the cell to the right of the cell that was located in
Book 2.

Does that make sense?
--
Sherry


"Roger Govier" wrote:

Hi Sherry

You say separate workbooks, do you truly mean that, or separate sheets?

If separate books then in B2 of Book2
=VLOOKUP(A2,[Book1.xls]Sheet1!$A$2:$B$100,2,0)
change sheet names and ranges to suit.

If just separate sheets in the same boo, then
=VLOOKUP(A2,Sheet1!$A$2:$B$100,2,0)

NOTE, in your example, you have multiple occurrences of code 101 and 319.
The formula will only return the value to the right of the first occurrence.


Regards

Roger Govier


Ladypep wrote:
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