Lookup with note/comment and show multiple cell values

%3CLINGO-SUB%20id%3D%22lingo-sub-2423008%22%20slang%3D%22en-US%22%3ELookup%20with%20note%2Fcomment%20and%20show%20multiple%20cell%20values%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2423008%22%20slang%3D%22en-US%22%3E%3CP%3EHi%20Team%2C%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20just%20got%20a%20job%20as%20warehouse%20manager%20and%20need%20to%20work%20with%20excel%20a%20lot%20for%20inventory%20control.%3C%2FP%3E%3CP%3EMay%20I%20know%20if%20Lookup%20could%20search%20with%20note%20and%20show%20the%20value%20of%20multiple%20cell%3F%20(We%20put%20the%20loadout%23%20with%20Note%20area%20and%20sometime%201%20loadout%20number%20have%20multiple%20item.)%3C%2FP%3E%3CP%3ELike%20attached%20sheet%20i%20want%20to%20lookup%20BL%235525%20in%20note%20area(Cell%23%20N2%2C%20L3%2C%20K6%20and%20M13%20and%20display%20column%20A%3AI%20on%20sheet%202.%3C%2FP%3E%3CP%3EI%20tried%20xlookup%20but%20it%20could%20only%20show%201%20row%20with%20lookup%20cell%20value.%3C%2FP%3E%3CP%3EI've%20attached%20a%20shorten%20version%20of%20the%20excel%20sheet%20we%20use.%3C%2FP%3E%3CP%3EPlease%20help.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-2423008%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E
Occasional Visitor

Hi Team,

 

I just got a job as warehouse manager and need to work with excel a lot for inventory control.

May I know if Lookup could search with note and show the value of multiple cell? (We put the loadout# with Note area and sometime 1 loadout number have multiple item.)

Like attached sheet i want to lookup BL#5525 in note area(Cell# N2, L3, K6 and M13 and display column A:I on sheet 2.

I tried xlookup but it could only show 1 row with lookup cell value.

I've attached a shorten version of the excel sheet we use.

Please help.

0 Replies