CURRENT FORMULA:
=IF(ISNA(LOOKUP(B19,$N$16:$S$34)),"",LOOKUP(B19,$N$16:$S$34))
I NEED TO EXPAND ARRAY TO 60 ROWS. IT WOULD
BETTER IF I DID NOT HAVE TO SORT FIRST ROW IN NUMBERICAL ORDER. THIS IS FOR A SHIPPING DOCUMENT - WE ENTER INVENTORY ITEM # INTO B19
I WOULD LIKE TO SORT ARRAY BY PRODUCT DESCRIPTION (COLUMN S)
I AM LOOKING FOR AN ALTERNATE FORMULA
I APPRECIATE ANY HELP. THANK YOU IN ADVANCE
FOR YOUR TIME.
=IF(ISNA(LOOKUP(B19,$N$16:$S$34)),"",LOOKUP(B19,$N$16:$S$34))
I NEED TO EXPAND ARRAY TO 60 ROWS. IT WOULD
BETTER IF I DID NOT HAVE TO SORT FIRST ROW IN NUMBERICAL ORDER. THIS IS FOR A SHIPPING DOCUMENT - WE ENTER INVENTORY ITEM # INTO B19
I WOULD LIKE TO SORT ARRAY BY PRODUCT DESCRIPTION (COLUMN S)
I AM LOOKING FOR AN ALTERNATE FORMULA
I APPRECIATE ANY HELP. THANK YOU IN ADVANCE
FOR YOUR TIME.