Jan 01 2022 01:21 AM
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 .
Jan 01 2022 02:45 AM
SolutionJan 02 2022 12:22 AM
@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/
Jan 01 2022 02:45 AM
SolutionAssuming Excel 365, Sheet2:B1
=XLOOKUP(A1;Sheet1!A:A;Sheet1!B:C)
Sheet1