jdnien2021 , glad to know you sorted this out
i have select cells from my lookup that are not being brought over as they should be. i have attached scheen shots of the issue. the blue and white page is where it pulls to and the white page is where it pulls from. i also included my formula that has worked upto this point.
Oops, I missed that. Yes, 4th parameter for VLOOKUP() defines approximate or exact search. If missed, that's approximate search. Try with 0 as 4th parameter (exact match).
","body@stringLength":"394","rawBody":"Oops, I missed that. Yes, 4th parameter for VLOOKUP() defines approximate or exact search. If missed, that's approximate search. Try with 0 as 4th parameter (exact match).
","author":{"__ref":"User:user:521"},"isEscalated":null,"postTime":"2022-01-20T04:15:54.219-08:00","parent":{"__ref":"ForumReplyMessage:message:3066565"}},"ForumReplyMessage:message:3067174":{"__typename":"ForumReplyMessage","id":"message:3067174","revisionNum":1,"uid":3067174,"depth":4,"hasGivenKudo":false,"subscribed":false,"board":{"__ref":"Forum:board:ExcelGeneral"},"conversation":{"__ref":"Conversation:conversation:3066152"},"subject":"Re: VLOOKUP formula not working for all cells","readOnly":false,"editFrozen":false,"moderationData":{"__ref":"ModerationData:moderation_data:3067174"},"body":"tried =IF(B18=\"\",\"\",VLOOKUP($B18,Price12521,2)0) and it corrects it to =IF(B18=\"\",\"\",VLOOKUP($B18,Price12521,2)*0) and then i get a value error with the formula. unless im putting it in the wrong spot.","body@stringLength":"201","rawBody":"tried =IF(B18=\"\",\"\",VLOOKUP($B18,Price12521,2)0) and it corrects it to =IF(B18=\"\",\"\",VLOOKUP($B18,Price12521,2)*0) and then i get a value error with the formula. unless im putting it in the wrong spot.","author":{"__ref":"User:user:1280736"},"isEscalated":null,"postTime":"2022-01-20T07:28:50.356-08:00","parent":{"__ref":"ForumReplyMessage:message:3066945"}},"ForumReplyMessage:message:3067178":{"__typename":"ForumReplyMessage","id":"message:3067178","revisionNum":1,"uid":3067178,"depth":5,"hasGivenKudo":false,"subscribed":false,"board":{"__ref":"Forum:board:ExcelGeneral"},"conversation":{"__ref":"Conversation:conversation:3066152"},"subject":"Re: VLOOKUP formula not working for all cells","readOnly":false,"editFrozen":false,"moderationData":{"__ref":"ModerationData:moderation_data:3067178"},"body":"=IF(B18=\"\",\"\",VLOOKUP($B18,Price12521,2,0))","body@stringLength":"43","rawBody":"=IF(B18=\"\",\"\",VLOOKUP($B18,Price12521,2,0))","author":{"__ref":"User:user:1278612"},"isEscalated":null,"postTime":"2022-01-20T07:32:00.442-08:00","parent":{"__ref":"ForumReplyMessage:message:3067174"},"customFields":[],"attachments":{"__typename":"AttachmentConnection","edges":[],"pageInfo":{"__typename":"PageInfo","hasNextPage":false,"endCursor":null,"hasPreviousPage":false,"startCursor":null}},"repliesCount":2},"Revision:revision:3067387_1":{"__typename":"Revision","id":"revision:3067387_1","lastEditTime":"2022-01-20T09:57:19.582-08:00"},"QueryVariables:ReplyList:message:3067387:1":{"__typename":"QueryVariables","id":"ReplyList:message:3067387:1","value":{"id":"message:3067387","first":10,"sorts":{"postTime":{"direction":"DESC"}},"repliesFirst":3,"repliesFirstDepthThree":1,"repliesSorts":{"postTime":{"direction":"DESC"}},"useAvatar":true,"useAuthorLogin":true,"useAuthorRank":true,"useBody":true,"useKudosCount":true,"useTimeToRead":false,"useMedia":false,"useReadOnlyIcon":false,"useRepliesCount":true,"useSearchSnippet":false,"useAcceptedSolutionButton":true,"useSolvedBadge":false,"useAttachments":false,"attachmentsFirst":5,"useTags":false,"useNodeAncestors":false,"useUserHoverCard":false,"useNodeHoverCard":false,"useModerationStatus":true,"usePreviewSubjectModal":false,"useMessageStatus":true}},"ROOT_MUTATION":{"__typename":"Mutation"},"CachedAsset:text:en_US-shared/client/components/users/UserAvatar-1743151752969":{"__typename":"CachedAsset","id":"text:en_US-shared/client/components/users/UserAvatar-1743151752969","value":{"altText":"{login}'s avatar","altTextGeneric":"User's avatar"},"localOverride":false},"CachedAsset:text:en_US-shared/client/components/ranks/UserRankLabel-1743151752969":{"__typename":"CachedAsset","id":"text:en_US-shared/client/components/ranks/UserRankLabel-1743151752969","value":{"altTitle":"Icon for {rankName} rank"},"localOverride":false},"CachedAsset:text:en_US-components/messages/AcceptedSolutionButton-1743151752969":{"__typename":"CachedAsset","id":"text:en_US-components/messages/AcceptedSolutionButton-1743151752969","value":{"accept":"Mark as Solution","accepted":"Marked as Solution","errorHeader":"Error!","errorAdd":"There was an error marking as solution.","errorRemove":"There was an error unmarking as solution.","solved":"Solved"},"localOverride":false},"CachedAsset:text:en_US-components/messages/ThreadedReplyList-1743151752969":{"__typename":"CachedAsset","id":"text:en_US-components/messages/ThreadedReplyList-1743151752969","value":{"title":"{count, plural, one{# Reply} other{# Replies}}","title@board:BLOG":"{count, plural, one{# Comment} other{# Comments}}","title@board:TKB":"{count, plural, one{# Comment} other{# Comments}}","title@board:IDEA":"{count, plural, one{# Comment} other{# Comments}}","title@board:OCCASION":"{count, plural, one{# Comment} other{# Comments}}","noRepliesTitle":"No Replies","noRepliesTitle@board:BLOG":"No Comments","noRepliesTitle@board:TKB":"No Comments","noRepliesTitle@board:IDEA":"No Comments","noRepliesTitle@board:OCCASION":"No Comments","noRepliesDescription":"Be the first to reply","noRepliesDescription@board:BLOG":"Be the first to comment","noRepliesDescription@board:TKB":"Be the first to comment","noRepliesDescription@board:IDEA":"Be the first to comment","noRepliesDescription@board:OCCASION":"Be the first to comment","messageReadOnlyAlert:BLOG":"Comments have been turned off for this post","messageReadOnlyAlert:TKB":"Comments have been turned off for this article","messageReadOnlyAlert:IDEA":"Comments have been turned off for this idea","messageReadOnlyAlert:FORUM":"Replies have been turned off for this discussion","messageReadOnlyAlert:OCCASION":"Comments have been turned off for this event"},"localOverride":false},"ModerationData:moderation_data:3067519":{"__typename":"ModerationData","id":"moderation_data:3067519","status":"APPROVED","rejectReason":null,"isReportedAbuse":false,"rejectUser":null,"rejectTime":null,"rejectActorType":null},"ForumReplyMessage:message:3067519":{"__typename":"ForumReplyMessage","author":{"__ref":"User:user:521"},"id":"message:3067519","revisionNum":1,"uid":3067519,"depth":7,"hasGivenKudo":false,"subscribed":false,"board":{"__ref":"Forum:board:ExcelGeneral"},"parent":{"__ref":"ForumReplyMessage:message:3067387"},"conversation":{"__ref":"Conversation:conversation:3066152"},"subject":"Re: VLOOKUP formula not working for all cells","moderationData":{"__ref":"ModerationData:moderation_data:3067519"},"body":"jdnien2021 , glad to know you sorted this out
","body@stripHtml({\"removeProcessingText\":false,\"removeSpoilerMarkup\":false,\"removeTocMarkup\":false,\"truncateLength\":200})@stringLength":"52","kudosSumWeight":0,"repliesCount":0,"postTime":"2022-01-20T12:16:32.114-08:00","lastPublishTime":"2022-01-20T12:16:32.114-08:00","metrics":{"__typename":"MessageMetrics","views":1756},"visibilityScope":"PUBLIC","placeholder":false,"originalMessageForPlaceholder":null,"isEscalated":null,"solution":false,"entityType":"FORUM_REPLY","eventPath":"category:microsoft365/category:products-services/category:communities/community:gxcuf89792board:ExcelGeneral/message:3066152/message:3067519","replies":{"__typename":"MessageConnection","pageInfo":{"__typename":"PageInfo","hasNextPage":false,"endCursor":null,"hasPreviousPage":false,"startCursor":null},"edges":[]},"customFields":[],"attachments":{"__typename":"AttachmentConnection","edges":[],"pageInfo":{"__typename":"PageInfo","hasNextPage":false,"endCursor":null,"hasPreviousPage":false,"startCursor":null}}},"CachedAsset:text:en_US-components/tags/TagView/TagViewChip-1743151752969":{"__typename":"CachedAsset","id":"text:en_US-components/tags/TagView/TagViewChip-1743151752969","value":{"tagLabelName":"Tag name {tagName}"},"localOverride":false}}}},"page":"/forums/ForumMessagePage/ForumMessagePage","query":{"boardId":"excelgeneral","messageSubject":"vlookup-formula-not-working-for-all-cells","messageId":"3066152","replyId":"3067387"},"buildId":"HEhyUrv5OXNBIbfCLaOrw","runtimeConfig":{"buildInformationVisible":false,"logLevelApp":"info","logLevelMetrics":"info","openTelemetryClientEnabled":false,"openTelemetryConfigName":"o365","openTelemetryServiceVersion":"25.1.0","openTelemetryUniverse":"prod","openTelemetryCollector":"http://localhost:4318","openTelemetryRouteChangeAllowedTime":"5000","apolloDevToolsEnabled":false,"inboxMuteWipFeatureEnabled":false},"isFallback":false,"isExperimentalCompile":false,"dynamicIds":["./components/seo/QAPageSchema/QAPageSchema.tsx","./components/community/Navbar/NavbarWidget.tsx","./components/community/Breadcrumb/BreadcrumbWidget.tsx","./components/customComponent/CustomComponent/CustomComponent.tsx","./components/messages/TopicWithThreadedReplyListWidget/TopicWithThreadedReplyListWidget.tsx","./components/external/components/ExternalComponent.tsx","./components/messages/MessageView/MessageViewStandard/MessageViewStandard.tsx","../shared/client/components/common/List/UnwrappedList/UnwrappedList.tsx","./components/tags/TagView/TagView.tsx","./components/tags/TagView/TagViewChip/TagViewChip.tsx","../shared/client/components/common/List/UnstyledList/UnstyledList.tsx","./components/messages/MessageView/MessageView.tsx"],"appGip":true,"scriptLoader":[{"id":"analytics","src":"https://techcommunity.microsoft.com/t5/s/gxcuf89792/pagescripts/1730819800000/analytics.js?page.id=ForumReplyPage&entity.id=board%3Aexcelgeneral&entity.id=message%3A3067387","strategy":"afterInteractive"}]}
