VLookUp or Join/Collect with multiple cell entiers not working

Options

Hi,

I am struggling with a tricky formular - need help.

What do I want?

  1. I type in cell (Lot joined / 10) any Lot Number e.g. "LHA1" (--> see "black circle 1")
  2. In cell (Lot joined / 11) only those TW numbers should be returned/displayed that are in the same line as the Lot Number "LHA1" in the yellow table above.

Thx.

Paul

Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!