working on a table with a long list of items. need to query the table to see if an item is listed without erroring out every time.
how can I check to see if "Black" is on the list and return a "N/A" or something I can use?
Any help will be appreciated. Ed.
You may use "try... on error ..." in your function SPBKUP to catch the error and return an appropriate result like NaN or a text message.
You may also consider using just lookup in your function ColNo instead of that combination of hlookup and match..
Actually I see no need for the function ColNo.
You could simply use
Of course you can replace indices 0 and 1 by ORIGIN and ORIGIN+1 to make the function ORIGIN independent.
For further help and future questions pls attach your worksheet and state which version of Prime you are using.
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.
