vlookup.

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hello.
I am using vlookup to lookup a value from coloumn A and display the
corresponding coloumn in the same row coloum C.
I want to have vlookup look for value in coloumn A and also in coloumn A of
another worksheet in the same workbook. Is this possible using vlookup? what
else can i use?

Thanks.
 
Amit,

Let's assume your range is A1:C10 on both worksheets (sheet 1 & 2), and you
are looking up the value in E1.

On sheet1:

=VLOOKUP(E1,$A$1:$C$10,3,FALSE)
will find the value in column C where the value in column A matches cell E1
precisely.

=VLOOKUP(E1,Sheet2!$A$1:$C$10,3,FALSE)
will look the value from cell E1 (on sheet1) up on sheet2 and return the
value from column C on sheet2 which matches exactly.

HTH

Pete
 
If the value you are looking for is on Sheet1 in cell E1, and your second
table is on sheet2, the following will work:

=VLOOKUP(E1,Sheet2!A:C,3,FALSE)
 
Back
Top