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.

  • Welcome. The question isn't clear. What means [Name].[phones ],[Name].[e-mail] and [sheet1.name] [sheet2.Email]? – Rubén Mar 8 at 16:09
  • is column '..... – Ahmed Abdulaziz Mar 8 at 16:22
  • col1= name col2= phones on sheet1 – Ahmed Abdulaziz Mar 8 at 16:23
  • Col1= name Col2= phons on sheet2 – Ahmed Abdulaziz Mar 8 at 16:24
  • I want to import data only if col1 on sheet1 (=) or like * col 1on sheet 2 – Ahmed Abdulaziz Mar 8 at 16:27
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
    thanks my dear for your time .... you are the best – Ahmed Abdulaziz Mar 8 at 19:37

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

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