Hello - How can I get a window or GUI lookup in Excel?
Sheet1 will have the lookup windows - Sheet2 the data table
Also, for the input of the lookup, it would be great if it could conduct a fuzzy search. For example, 0346 is the input of the search and the output = the barcode for item # 100.00346
Finally, 2 search windows needed - each search is on a 2 column data set (item # / barcode for the item # & Job Number / barcode for the item #).
thx!
mn
Sheet1 will have the lookup windows - Sheet2 the data table
Also, for the input of the lookup, it would be great if it could conduct a fuzzy search. For example, 0346 is the input of the search and the output = the barcode for item # 100.00346
Finally, 2 search windows needed - each search is on a 2 column data set (item # / barcode for the item # & Job Number / barcode for the item #).
thx!
mn
