1

I have two sheets -

Sheet1 includes:

col 1  | col 2 
[Name] | [phones ]

Sheet2 includes:

col 1  | col 2
[Name] | [e-mail]

I want to importrange if the name on Sheet1 is equal to name on Sheet2.

6
  • Welcome. The question isn't clear. What means [Name].[phones ],[Name].[e-mail] and [sheet1.name] [sheet2.Email]? Mar 8, 2019 at 16:09
  • is column '..... Mar 8, 2019 at 16:22
  • col1= name col2= phones on sheet1 Mar 8, 2019 at 16:23
  • Col1= name Col2= phons on sheet2 Mar 8, 2019 at 16:24
  • I want to import data only if col1 on sheet1 (=) or like * col 1on sheet 2 Mar 8, 2019 at 16:27

1 Answer 1

0
  • use VLOOKUP formula. paste this formula in cell C1 on Sheet2:

    =ARRAYFORMULA(IFERROR(VLOOKUP(A:A, Sheet1!A:B, 2, 0), ))

    =ARRAYFORMULA(IFERROR(VLOOKUP(FILTER(Sheet1!A1:A,
     ISNUMBER(SEARCH("*"&A1:A&"*",A1:A))), Sheet1!A1:B, 2, 0), ))

1
  • 1
    thanks my dear for your time .... you are the best Mar 8, 2019 at 19:37

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Not the answer you're looking for? Browse other questions tagged or ask your own question.