Good Morning Excel'ers
I am trying to validate data across tabs within a workbook. The data is alphanumeric Formated as (ABC123). In the data validation options I've tied =isnumber(match(A1,list,0)) but only works for numbers. I'ved tried =istext(match(A1,list,0)) but no luck.
Do any of you have any insight on how to validate a large list of alphanumeric characters on a seperate tab?
Thanks
JP
Bookmarks