Tuesday 11 April 2017

Vlookup ,fetching values from one sheet to another Sheet in Excel:

Note : If col1 from Sheet1 is matching with Col1 Sheet2 then return
[Sheet1].Extracted Values]=[Sheet2].[Fetching Values]
Formula :
=IF(LEN(A3)>1,VLOOKUP(A3,Sheet2!A:B,2,0),"")
Notes : (A3) is my start postion in sheet1
or
=IF(LEN(A1)>1,VLOOKUP(A:A,Sheet2!A:B,2,0),"")
Notes : (A1) is my start postion in sheet1

No comments:

Post a Comment