Dear Jeffa,

try this:

=Vlookup(A2,OVSDDUMP!A:B,2,false)

HTH

"Jeffa" wrote:

Hello,

I have a 2 worksheets.. one has in it a list of asset numbers
The other has all the asset numbers, descriptions etc of the assets.
I want to be able to have a formula in colunm B that looks up the asset
number in colunm A but in the other worksheet, and then reports on what the
description is.

I thought this would work but it didnt..
=lookup(A2,OVSDDUMP!A:B)

I was hoping that would look up the A2 asset number and the A colunm of the
OVSDDUMP sheet and report back what is in the B colunm of that row.

Any help here would be appriciated.

Regards,

Jeffrey