SOLVED

# FORMULA AND FUNCTIONS

Occasional Contributor

# FORMULA AND FUNCTIONS

I Want to fetch data on sheet 2 , from sheet 1
like as if there is address:  A1 named 'apple' in sheet 1
as soon as i fill ' apple' in sheet 2 , other cells automatically get filled matching the data on sheet 1 in row 'apple'. please help .

3 Replies
best response confirmed by aayushmanmishra (Occasional Contributor)
Solution

# Re: FORMULA AND FUNCTIONS

Assuming Excel 365, Sheet2:B1

``=XLOOKUP(A1;Sheet1!A:A;Sheet1!B:C)``

Sheet1

# Re: FORMULA AND FUNCTIONS

I m using excel 2019 currently.

# Re: FORMULA AND FUNCTIONS

@aayushmanmishraWith versions pre dynamic arrays you have to have a formula for each result. (With dynamic arrays, one formula can spill the result to as many cells that are plausible.(

``=VLOOKUP(\$A1;Sheet1!\$A:\$SIT;COLUMNS(\$A:B);0)``

It is the same formula in both cells.

COLUMNS is used to return 2 in column b and 3 in column c making the same formula fetching data for the different columns.