Hi

No reason why it shouldn't work

=VLOOKUP('Your first sheet'!A1,'Your second sheet'!$A$1:$G$100,2,0)

Change sheet references and ranges to suit.

Regards

Roger Govier


tapaspanda wrote:
Can anyone help on this? I am trying to use vlookup function to look for
value in another worksheet. But is doesn't work. Is it supposed be that
way? What is a way around to solve a problem like this?
Thanks in advance.
Tapas