ahumne✭

This work Range 2: 19 Columns x 3900 -> This doesn't work. Gives \"#NO MATCH\" error. Could you please suggest what what to do? Best Regards, Adarsh","categoryID":322,"dateInserted":"2020-12-02T09:00:02+00:00","dateUpdated":null,"dateLastComment":"2020-12-17T12:55:42+00:00","insertUserID":88821,"insertUser":{"userID":88821,"name":"ahumne","url":"https:\/\/community.smartsheet.com\/profile\/ahumne","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2020-12-17T15:51:13+00:00","banned":0,"punished":0,"private":false,"label":"✭"},"updateUserID":null,"lastUserID":127340,"lastUser":{"userID":127340,"name":"Bassam Khalil","title":"","url":"https:\/\/community.smartsheet.com\/profile\/Bassam%20Khalil","photoUrl":"https:\/\/lh3.googleusercontent.com\/a\/AAcHTtf7UK_uIEyXZAONqmsQXBPSfVi5-GCzNLZawKE6bV9IIEk=s96-c","dateLastActive":"2023-07-18T09:22:17+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭✭✭✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":3,"countViews":62,"score":null,"hot":3,"url":"https:\/\/community.smartsheet.com\/discussion\/73604\/vlookup-error","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/73604\/vlookup-error","format":"Rich","groupID":null,"statusID":2,"attributes":{"question":{"status":"answered","dateAccepted":null,"dateAnswered":null,"acceptedAnswers":[]}},"bookmarked":false,"unread":false,"category":{"categoryID":322,"name":"Formulas and Functions","url":"https:\/\/community.smartsheet.com\/categories\/formulas-and-functions","allowedDiscussionTypes":[]},"tags":[],"reactions":[{"tagID":3,"urlcode":"Promote","name":"Promote","class":"Positive","hasReacted":false,"reactionValue":5,"count":0},{"tagID":5,"urlcode":"Insightful","name":"Insightful","class":"Positive","hasReacted":false,"reactionValue":1,"count":0},{"tagID":11,"urlcode":"Up","name":"Vote Up","class":"Positive","hasReacted":false,"reactionValue":1,"count":0},{"tagID":13,"urlcode":"Awesome","name":"Awesome","class":"Positive","hasReacted":false,"reactionValue":1,"count":0}]},{"discussionID":73603,"type":"question","name":"VLOOKUP ERROR","excerpt":"Hello, I wanted to use VLOOKUP for referencing cells within the same sheet. But it only works for certain range: Range 1: 19 Columns x 3800 Rows -> This work Range 2: 19 Columns x 3900 -> This doesn't work. Gives \"#NO MATCH\" error. Could you please suggest what what to do? Best Regards, Adarsh","categoryID":322,"dateInserted":"2020-12-02T08:59:58+00:00","dateUpdated":null,"dateLastComment":"2020-12-02T09:04:05+00:00","insertUserID":88821,"insertUser":{"userID":88821,"name":"ahumne","url":"https:\/\/community.smartsheet.com\/profile\/ahumne","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2020-12-17T15:51:13+00:00","banned":0,"punished":0,"private":false,"label":"✭"},"updateUserID":null,"lastUserID":8888,"lastUser":{"userID":8888,"name":"Andrée Starå","title":"Smartsheet Expert Consultant & Partner | Workflow Consultant \/ CEO @ WORK BOLD","url":"https:\/\/community.smartsheet.com\/profile\/Andr%C3%A9e%20Star%C3%A5","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/userpics\/0PAU3GBYQLBT\/nXWM7QXGD6464.jpg","dateLastActive":"2023-08-21T07:06:27+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭✭✭✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":1,"countViews":51,"score":null,"hot":1,"url":"https:\/\/community.smartsheet.com\/discussion\/73603\/vlookup-error","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/73603\/vlookup-error","format":"Rich","groupID":null,"statusID":2,"attributes":{"question":{"status":"answered","dateAccepted":null,"dateAnswered":null,"acceptedAnswers":[]}},"bookmarked":false,"unread":false,"category":{"categoryID":322,"name":"Formulas and Functions","url":"https:\/\/community.smartsheet.com\/categories\/formulas-and-functions","allowedDiscussionTypes":[]},"tags":[],"reactions":[{"tagID":3,"urlcode":"Promote","name":"Promote","class":"Positive","hasReacted":false,"reactionValue":5,"count":0},{"tagID":5,"urlcode":"Insightful","name":"Insightful","class":"Positive","hasReacted":false,"reactionValue":1,"count":0},{"tagID":11,"urlcode":"Up","name":"Vote Up","class":"Positive","hasReacted":false,"reactionValue":1,"count":0},{"tagID":13,"urlcode":"Awesome","name":"Awesome","class":"Positive","hasReacted":false,"reactionValue":1,"count":0}]},{"discussionID":49726,"type":"discussion","name":"Copy colour format from one sheet to another","excerpt":"Hi I want to copy the colour formatting of all the columns in one sheet to around 50 other sheet. Is there a way to do it? Currently I have to format each sheet individually. Paste Special is not working for me to copy the format. Thanks, Adarsh","categoryID":321,"dateInserted":"2019-06-04T03:44:05+00:00","dateUpdated":"2019-12-09T08:04:32+00:00","dateLastComment":"2019-06-04T13:57:38+00:00","insertUserID":88821,"insertUser":{"userID":88821,"name":"ahumne","url":"https:\/\/community.smartsheet.com\/profile\/ahumne","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2020-12-17T15:51:13+00:00","banned":0,"punished":0,"private":false,"label":"✭"},"updateUserID":null,"lastUserID":45516,"lastUser":{"userID":45516,"name":"Paul Newcome","title":"","url":"https:\/\/community.smartsheet.com\/profile\/Paul%20Newcome","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/userpics\/082\/nQPUTVFKKWDJ2.jpg","dateLastActive":"2023-08-20T03:23:12+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭✭✭✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":4,"countViews":220,"score":null,"hot":4,"url":"https:\/\/community.smartsheet.com\/discussion\/49726\/copy-colour-format-from-one-sheet-to-another","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/49726\/copy-colour-format-from-one-sheet-to-another","format":"Html","groupID":null,"statusID":0,"attributes":{},"bookmarked":false,"unread":false,"category":{"categoryID":321,"name":"Smartsheet Basics","url":"https:\/\/community.smartsheet.com\/categories\/smartsheet-basics%2B","allowedDiscussionTypes":[]},"tags":[],"reactions":[{"tagID":3,"urlcode":"Promote","name":"Promote","class":"Positive","hasReacted":false,"reactionValue":5,"count":0},{"tagID":5,"urlcode":"Insightful","name":"Insightful","class":"Positive","hasReacted":false,"reactionValue":1,"count":0},{"tagID":11,"urlcode":"Up","name":"Vote Up","class":"Positive","hasReacted":false,"reactionValue":1,"count":0},{"tagID":13,"urlcode":"Awesome","name":"Awesome","class":"Positive","hasReacted":false,"reactionValue":1,"count":0}]}],"title":null,"subtitle":null,"description":null,"viewAllUrl":null,"isMainContent":false,"noCheckboxes":true}">