Trying to bring the data

%3CLINGO-SUB%20id%3D%22lingo-sub-2008556%22%20slang%3D%22en-US%22%3ETrying%20to%20bring%20the%20data%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2008556%22%20slang%3D%22en-US%22%3E%3CP%3EHi%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20am%20trying%20to%20populate%20the%20cell%20values%20in%20sheet%201%2C%20how%20can%20i%20do%20this%20i%20am%20working%20on%20data%20with%20more%20than%2010000.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EMy%20question%3A%20I%20have%20a%20data%20worksheet%20and%20sheet%201%20in%20the%20attached%20file.%20If%20the%20cell%20value%20in%20column%20A%20from%20sheet%201%20is%20equals%20to%20column%20A%20in%20data%20worksheet.%20I%20want%20the%20respective%20fields%20to%20populate%20using%20formula.%20How%20can%20I%20get%20this%20done.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-2008556%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EBI%20%26amp%3B%20Data%20Analysis%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EDeveloper%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EExcel%20for%20web%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EFormulas%20and%20Functions%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EOffice%20365%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2008614%22%20slang%3D%22en-US%22%3ERe%3A%20Trying%20to%20bring%20the%20data%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2008614%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F783518%22%20target%3D%22_blank%22%3E%40Krishck%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EIn%20B2%20on%20Sheet1%3A%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3E%3DINDEX(data!%24B%242%3A%24BH%24296%2CMATCH(%24A2%2Cdata!%24A%242%3A%24A%24296%2C0)%2CMATCH(B%241%2Cdata!%24B%241%3A%24BH%241%2C0))%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EAdjust%20the%20ranges%20if%20necessary.%3C%2FP%3E%0A%3CP%3EFill%20to%20the%20right%2C%20then%20down%20(or%20vice%20versa)%3C%2FP%3E%3C%2FLINGO-BODY%3E
Occasional Contributor

Hi

 

I am trying to populate the cell values in sheet 1, how can i do this i am working on data with more than 10000.

 

My question: I have a data worksheet and sheet 1 in the attached file. If the cell value in column A from sheet 1 is equals to column A in data worksheet. I want the respective fields to populate using formula. How can I get this done.

1 Reply

@Krishck 

In B2 on Sheet1:

 

=INDEX(data!$B$2:$BH$296,MATCH($A2,data!$A$2:$A$296,0),MATCH(B$1,data!$B$1:$BH$1,0))

 

Adjust the ranges if necessary.

Fill to the right, then down (or vice versa)