Lookup values in cells columns in another sheet

%3CLINGO-SUB%20id%3D%22lingo-sub-1935211%22%20slang%3D%22en-US%22%3ELookup%20values%20in%20cells%20columns%20in%20another%20sheet%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1935211%22%20slang%3D%22en-US%22%3E%3CP%3EI%20would%20like%20lookup%20values%20or%20text%20in%20cells%20in%20columns%20from%20another%20sheet%20in%20the%20same%20XL%20document.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1935211%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1935313%22%20slang%3D%22en-US%22%3ERe%3A%20Lookup%20values%20in%20cells%20columns%20in%20another%20sheet%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1935313%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F883172%22%20target%3D%22_blank%22%3E%40tripoptrading%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CEM%3EYou%20may%20try%20this%3A%3C%2FEM%3E%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%22Rajesh-S_0-1606462127288.png%22%20style%3D%22width%3A%20400px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F236320iD1472E438BF65E89%2Fimage-size%2Fmedium%3Fv%3D1.0%26amp%3Bpx%3D400%22%20role%3D%22button%22%20title%3D%22Rajesh-S_0-1606462127288.png%22%20alt%3D%22Rajesh-S_0-1606462127288.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3CUL%3E%3CLI%3EFormula%20in%20Sheet2%20cell%20E14%3A%3C%2FLI%3E%3C%2FUL%3E%3CPRE%20class%3D%22lia-code-sample%20language-applescript%22%3E%3CCODE%3E%3DIFERROR(INDEX(Sheet1!B%2414%3AB%2419%2CMATCH(%24D14%2CSheet1!%24A%2414%3A%24A%2419%2C0))%2C%22%22)%3C%2FCODE%3E%3C%2FPRE%3E%3CUL%3E%3CLI%3E%3CEM%3EFill%20the%20formula%20across%20required%20Range.%3C%2FEM%3E%3C%2FLI%3E%3CLI%3E%3CEM%3EAdjust%20cell%20references%20in%20the%20formula%20as%20needed.%3C%2FEM%3E%3C%2FLI%3E%3C%2FUL%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E
Occasional Visitor

I would like lookup values or text in cells in columns from another sheet in the same XL document.

1 Reply

@tripoptrading 

 

You may try this:

 

Rajesh-S_0-1606462127288.png

  • Formula in Sheet2 cell E14:

 

=IFERROR(INDEX(Sheet1!B$14:B$19,MATCH($D14,Sheet1!$A$14:$A$19,0)),"")

 

  • Fill the formula across required Range.
  • Adjust cell references in the formula as needed.