Home

Entry validation based on input in another cell

%3CLINGO-SUB%20id%3D%22lingo-sub-874224%22%20slang%3D%22en-US%22%3EEntry%20validation%20based%20on%20input%20in%20another%20cell%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-874224%22%20slang%3D%22en-US%22%3E%3CP%3EIs%20it%20possible%20to%20validate%20free%20text%20input%20in%20a%20cell%20and%20display%20in%20another%20cell%20if%20the%20input%20is%20accepted%20or%20not.%20For%20example%2C%20if%20I%20enter%20XXYYZZ%20in%20cell%20A1%2C%20is%20it%20possible%20to%20display%20in%20cell%20B2%20%22Verified%22%20or%20%22Not%20verified%22%2C%20for%20example%3F%20The%20input%20in%20XXYYZZ%20must%20be%20checked%20against%20a%20list.%20However%2C%20even%20if%20the%20input%20is%20not%20valid%2C%20the%20user%20should%20be%20allowed%20to%20continue%2C%20but%20simply%20receive%20a%20warning%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-874224%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%20Desktop%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-876546%22%20slang%3D%22en-US%22%3ERe%3A%20Entry%20validation%20based%20on%20input%20in%20another%20cell%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-876546%22%20slang%3D%22en-US%22%3E%3CP%3EHi%26nbsp%3B%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F414883%22%20target%3D%22_blank%22%3E%40AbiDK%3C%2FA%3E%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EExample%20file%20attached%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20style%3D%22width%3A%20999px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Fgxcuf89792.i.lithium.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F133604i937F376D3711BE16%2Fimage-size%2Flarge%3Fv%3D1.0%26amp%3Bpx%3D999%22%20alt%3D%22image.png%22%20title%3D%22image.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EHope%20that%20helps%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EWyn%3C%2FP%3E%3C%2FLINGO-BODY%3E
AbiDK
Occasional Visitor

Is it possible to validate free text input in a cell and display in another cell if the input is accepted or not. For example, if I enter XXYYZZ in cell A1, is it possible to display in cell B2 "Verified" or "Not verified", for example? The input in XXYYZZ must be checked against a list. However, even if the input is not valid, the user should be allowed to continue, but simply receive a warning

1 Reply

Hi @AbiDK

 

Example file attached

 

image.png

 

Hope that helps

 

Wyn

Related Conversations
Tabs and Dark Mode
cjc2112 in Discussions on
16 Replies
Stable version of Edge insider browser
HotCakeX in Discussions on
35 Replies
flashing a white screen while open new tab
cntvertex in Discussions on
11 Replies
How to Prevent Teams from Auto-Launch
chenrylee in Microsoft Teams on
28 Replies