G
Guest
Hi,
I have 2 worksheets in a workbook:
Sheet1:
Column A B C
row1 W X 3
row2 Y Z 4
Sheet2:
Column A B C
row1 Y Z
The value of cell C1 should be 4, according to sheet1
If I want to use vlookup function to retrieve the value from Sheet1, is it
possible to do so? Since I am searching on more than 1 column......
Can anyone help? Thanks in advance.
I have 2 worksheets in a workbook:
Sheet1:
Column A B C
row1 W X 3
row2 Y Z 4
Sheet2:
Column A B C
row1 Y Z
The value of cell C1 should be 4, according to sheet1
If I want to use vlookup function to retrieve the value from Sheet1, is it
possible to do so? Since I am searching on more than 1 column......
Can anyone help? Thanks in advance.