G
Guest
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
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