Forum Discussion

Adhamelalfy's avatar
Adhamelalfy
Copper Contributor
Feb 20, 2023

Formula to auto enter data from another sheet

Hello,

I have 2 sheets in the same workbook

 

What I'm trying to figure out is how when I enter data in the "Service Provider" column C, It will auto enter the data in the colums D, E and F in sheet 1 based on the data stored in Sheet 2 (I want the service provider to be the key to join the two sheets)

 

 Thanks in advance...

excel
Formulas and Functions

3 Replies

    • Adhamelalfy's avatar
      Adhamelalfy
      Copper Contributor
      Feb 22, 2023
      Thank you so much for your quick reply, I realized I can't use the XLOOKUP formula as my workspace computer is running Office 2013. Unfortunately, it doesn't have this formula 😑

      Can you help me with another method for old office versions?
      • HansVogelaar's avatar
        HansVogelaar
        MVP
        Feb 22, 2023

        Adhamelalfy 

         

        In D3:

         

        =IFERROR(VLOOKUP($C3, Sheet2!$B$3:$E$6, COLUMN()-2, FALSE), "")

         

        Fill to the right to F3, then fill down.

Resources