Forum Discussion

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 she...

excel

Formulas and Functions

HansVogelaar

MVP

Feb 20, 2023

Adhamelalfy

In D3 on Sheet1:

=XLOOKUP(C3, Sheet2!$B$3:$B$6, Sheet2!$C$3:$E$6, "")

Fill down to D6.

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