SOLVED

FORMULA AND FUNCTIONS

Occasional Contributor

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

Hi @aayushmanmishra 

Assuming Excel 365, Sheet2:B1

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

bosinander_1-1641033887142.png

 

Sheet1

bosinander_2-1641033911926.png

 

I m using excel 2019 currently.

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

 

bosinander_0-1641111368838.png

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/