FORMULA AND FUNCTIONS

[aayushmanmishra]

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 . 

[#2 · Accepted solution]

Hi @aayushmanmishra 

Assuming Excel 365, Sheet2:B1

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

Sheet1

[#3]

I m using excel 2019 currently.

[#4]

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

For more info on vlookup, see eg https://exceloffthegrid.com/how-to-use-vlookup/