Jun 07 2021
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.