SOLVED

function help

%3CLINGO-SUB%20id%3D%22lingo-sub-1639574%22%20slang%3D%22en-US%22%3Efunction%20help%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1639574%22%20slang%3D%22en-US%22%3E%3CP%3EHi%2C%3C%2FP%3E%3CP%3EI%20am%20new%20to%20excel%20as%20I%20am%20learning%20to%20understand%20the%20usage%20and%20different%20ways%20on%20working%20on%20the%20data.%20I%20am%20attaching%20a%20sample%20sheet%2C%20which%20consists%20of%20two%20worksheets.%20I%20am%20looking%20for%20a%20way%20to%20use%20the%20level%20from%20worksheet%20named%20%22Level%22%20and%20bring%20that%20to%20test_data%20in%20yellow%20field.%20So%20that%20the%20formula%20can%20be%20copied%20all%20the%20way%20down%20easily%2C%20rather%20than%20bringing%20from%20another%20worksheet.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3ECan%20anyone%20help%20me%20out%20with%20a%20easy%20way%3F%20Thank%20you.%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1639574%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3ECharting%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EFormulas%20and%20Functions%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EMacros%20and%20VBA%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EOffice%20365%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1640131%22%20slang%3D%22en-US%22%3ERe%3A%20function%20help%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1640131%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%3BThat%20could%20be%2C%20in%20O2%3C%2FP%3E%3CPRE%20class%3D%22lia-code-sample%20language-excel%22%3E%3CCODE%3E%3DXLOOKUP(N2%2CLevel!B%3AB%2CLevel!C%3AC%2C%2C0)%3C%2FCODE%3E%3C%2FPRE%3E%3CP%3Eor%2C%20if%20you%20prefer%20to%20use%20%22good%20old%22%20VLOOKUP%2C%20try%20this%3C%2FP%3E%3CPRE%20class%3D%22lia-code-sample%20language-excel%22%3E%3CCODE%3E%3DVLOOKUP(N2%2CLevel!B%3AC%2C2%2C0)%3C%2FCODE%3E%3C%2FPRE%3E%3CP%3E%26nbsp%3Band%20copy%20it%20all%20the%20way%20down.%3C%2FP%3E%3C%2FLINGO-BODY%3E
Highlighted
New Contributor

Hi,

I am new to excel as I am learning to understand the usage and different ways on working on the data. I am attaching a sample sheet, which consists of two worksheets. I am looking for a way to use the level from worksheet named "Level" and bring that to test_data in yellow field. So that the formula can be copied all the way down easily, rather than bringing from another worksheet.

 

Can anyone help me out with a easy way? Thank you. 

1 Reply
Highlighted
Best Response confirmed by Krishck (New Contributor)
Solution

@Krishck That could be, in O2

=XLOOKUP(N2,Level!B:B,Level!C:C,,0)

or, if you prefer to use "good old" VLOOKUP, try this

=VLOOKUP(N2,Level!B:C,2,0)

 and copy it all the way down.