bardulinho
New Member
- Joined
- May 25, 2011
- Messages
- 1
Can someone help me out with this?
I have built a spreadsheet that uses Data Validation with the VLOOKUP function to prevent me from entering duplicate data...The formula I'm using is =ISNA(VLOOKUP(B100,B$2:B100,1,FALSE))...I am also using Conditional Formatting just in case Data Validation does not work..
However, I also have cases when the data I need checked for duplicates is not in the same format, but it really is the same thing.. Ex. I already have "TEST0000" listed, but I might receive the new data that is to be entered in the spreadsheet as "GW CYM TEST0000 Locked"... How can I make sure that each time "TEST0000" is entered in any format, no matter if it's surrounded by a bunch of other data in the same cell, I get the Data Validation tool to not allow me to enter that data?
Hope I made this clear and it makes any sense - thanks guys
I have built a spreadsheet that uses Data Validation with the VLOOKUP function to prevent me from entering duplicate data...The formula I'm using is =ISNA(VLOOKUP(B100,B$2:B100,1,FALSE))...I am also using Conditional Formatting just in case Data Validation does not work..
However, I also have cases when the data I need checked for duplicates is not in the same format, but it really is the same thing.. Ex. I already have "TEST0000" listed, but I might receive the new data that is to be entered in the spreadsheet as "GW CYM TEST0000 Locked"... How can I make sure that each time "TEST0000" is entered in any format, no matter if it's surrounded by a bunch of other data in the same cell, I get the Data Validation tool to not allow me to enter that data?
Hope I made this clear and it makes any sense - thanks guys
