Pls find attached excel file as an example.
on sheet1, cell B2, there is a data entry cell for user to input PO number, I know how to use data validation to restrict max. no. of characters of this field, but actually max. no. of characters (field length is a variable) that needs to look up cell C1 on Sheet2. How can I make it? Thanks.
Bookmarks