Vlookup from 2 different worksheets

[rakesh2806]

Hi,

I am learning vlookup. I have created two worksheets. Sheet one I have employee ID, quality score and then I have a successful vlook up. One the second sheet I am trying to get the quality score from sheet one using vlookup and I am getting an error message. Please correct me since I am getting an error message. I am doing the same thing that I have done on sheet one.

Regards

Rakesh

[dilipandey]

Hi Rakesh


Use below formula in C2 cell in sheet 2 and drag it down:-
=VLOOKUP(A2,Sheet1!$B$2:$C$5,2,0)

Regards,
DILIPandey

<click on below 'star' if this helps>

[rakesh2806]

Dilip,

It is working with your help. But could you please help me understand why the below one is not working?

=VLOOKUP(A2,Sheet1!$A$2:$C$5,3,0)

Regards

Rakesh

[rakesh2806]

It is working with your help. But could you please help me understand why the below one is not working?

=VLOOKUP(A2,Sheet1!$A$2:$C$5,3,0)

Regards

Rakesh

[dilipandey]

Hi Rakesh,

=VLOOKUP(A2,Sheet1!A2:C5,3,0)

here you are looking up A2 which is A in Sheet1's A:2:C5 which is starting from data as (1,2,3,4) and will fetch data as (100,99,98,97).. so the formula is not able to find A in (1,2,3,4) to give any matching result from (100,99,98,97) and that was the issue which I managed as :-

=VLOOKUP(A2,Sheet1!$B$2:$C$5,2,0)

Since column B of sheet 1 has (A,B,C,D) .. which fetched matching results from column C (100,99,98,97)

Regards,
DILIPandey


<click on below 'star' if this helps>