Roger,

Although I have just not found the time to get back to my original post to
check for replies, I wanted to tell you that your answer was dead-on and it
works perfectly. Thanks so very much for your help. Now my users think I'm a
genius...lol...but, sigh, I could not take the credit and had to 'fess up
that I had help.

Again thanks.
--
Sherry


"Roger Govier" wrote:

Hi Sherry

Frm your example, it looked as though you had headings in row 1, that's
why I started iwith A2.
However, I had misread which book was which.
Change the formula round

In cell B1 of Book1 enter

=VLOOKUP(A1,[Book2.xls]Sheet1!$A$2:$B$100,2,0)

Make the range as long as suits you, by altering the 100 as above to any value up to 65536

This will look down column A of Book2 for the value in A1 in Book and, if found will returb the adjacent value from column B of Book2.

I hope this is what you want.

Regards

Roger Govier



Ladypep wrote:

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?