LinkBack URL
About LinkBacks
How can i validate excel cell from other sheet below is my sheet example want to validate Sheet1 from Sheet2 as reference.
ATTACHING EXCEL FOR REFERENCE
How can i validate excel cell from other sheet below is my sheet example want to validate Sheet1 from Sheet2 as reference.
ATTACHING EXCEL FOR REFERENCE
How many variations are there of "IN_INXX": I assume that we need to test this and the corresponding format to be "nnn_nnn".
Please add an explanation of the validation.
Data Validation of cell B6:
Allow: Custom
Formula:
=ISNUMBER(SEARCH(VLOOKUP(A6,Sheet2!$A$2:$B$6,2,0),B6))
Copy/paste special: Validation >>> to B7
Quang PT
There can be many variations IN_IN013,IN_IN023 like this
So explain the validation you want performed: we are not mind-readers.
Add more examples to the file.
Select B6:B10
Data--> Data Validation
Custom--> Formula
Enter formula
=ISNUMBER(SEARCH(INDEX(Sheet2!$B$2:$B$10,MATCH($A6,Sheet2!$A$2:$A$10,0)),$B6,1))
Pl note
Array formula should be confirmed with Ctrl+Shift+Enter keys together.
If answere is satisfactory press * to add reputation.
Do you really want DV where the value in Column B is fixed against the value in Column A? If A is changed to 123-457 formulae fail.
or is 123-456 meant to represent a "generic" number i.e nnn-nnn
Its resolved thank you all for your time to look into this issue!
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks