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
[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