Can Vlookup look for values in another worksheet

  • Thread starter Thread starter tapaspanda
  • Start date Start date
T

tapaspanda

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
 
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
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Dynamic col_index_num in VLOOKUP? 5
Changing worksheet reference in a VLOOKUP 6
VLOOKUP 1
vlookup to another worksheet 3
Help With VLOOKUP 2
VLOOKUP PROBLEM 2
Vlookups not working 2
VLOOKUP worksheet function returns zero for empty cells 3

Back
Top