Folks:

Much appreciate any help out of this situation.

I have a worksheet that contains ten columns of data with 6,608 cells
in each column. Each cell is a mixed value of number + text (example:
03510.mp3).

In the same workbook I have another worksheet that contains columns
that provide the key to those mixed values. One column is the mixed
values (03510.mp3) and the adjacent column provides the definition in
text (example: Ray Bradbury).

What I want to do is have all 68,080 cells in the first worksheet look
up the key in the second worksheet and extract the key definition text.


I want the text definition added to my first worksheet (the one with
68,080 cells), so that I can identify each one of the values with its
text definition.

How do I do this?

I know enough to get in trouble because I've gone down the road of
trying to set up a formula that combines VLOOKUP with [WorkbookName]
linking. However, it's not working, so I must be doing something wrong.


Thanks for any illumination you can send my way!

Stephen