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)
"Amit" wrote:
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.
|