LinkBack URL
About LinkBacks
Grace Tan 
in which cell text of of > 256 characters is required. Because we have o in round about route to get text length of >256 .
Pl see file. I have given Example.
Validation list H7:H10
Text list I7:I10
Validated cells A1:A3
Required text cells (Result cells) B1:B3
Formula in B1 then copied down.
=IFERROR(INDEX($I$7:$I$10,MATCH($A1,$H$7:$H$10,0)),"")
Register To Reply
Bookmarks