Hi All,
I'm trying to get double verification worksheet created but don't know how to start.
Basically there are 3 tabs:
1. DATA_EXTRACT
2. PERFORMER
3. VERIFIER
DATA_EXTRACT tab will be hidden with all information about products etc and users will not be able to see it.
My question is: How can I do a lookup / match formula in two tabs (PERFORMER & VERIFIER), where PERFORMER tab and VERIFIER tab will have data entered by user to see if it is matching data in hidden sheet (DATA_EXTRACT). If data will be entered incorrectly - will not match what's in DATA_EXTRACT tab, user should get a message - warning that DATA ENTERED IS INCORRECT.
Can you help me build a formula / macro with something like that?
I'm trying to get double verification worksheet created but don't know how to start.
Basically there are 3 tabs:
1. DATA_EXTRACT
2. PERFORMER
3. VERIFIER
DATA_EXTRACT tab will be hidden with all information about products etc and users will not be able to see it.
My question is: How can I do a lookup / match formula in two tabs (PERFORMER & VERIFIER), where PERFORMER tab and VERIFIER tab will have data entered by user to see if it is matching data in hidden sheet (DATA_EXTRACT). If data will be entered incorrectly - will not match what's in DATA_EXTRACT tab, user should get a message - warning that DATA ENTERED IS INCORRECT.
Can you help me build a formula / macro with something like that?