I need to validate multiple cells in to one dropdown box. example: validate
a3:a23 (item #), b3:b18 (descriptions) and c3:c27 (prices) into one drop box.
I would like to type a item number in validated a4 and autofill a
description in b4 and a price in c4. Thanks