User Profile
JoB_19
Copper Contributor
Joined 7 years ago
User Widgets
Recent Discussions
Re: TRUE vlookup brings the wrong results
Maybe I misunderstood your goal using TRUE. You mention "speed things up"; not sure what you mean by that. Were you looking for approximate matches? Using TRUE gives you approximate matches . Using FALSE gives you exact matches. (see link below for a detailed explanation from Microsoft) Quick Reference Card by Microsoft.https://support.office.com/en-us/article/quick-reference-card-vlookup-refresher-750fe2ed-a872-436f-92aa-36c17e53f2ee For my project, I was looking for exact matches; therefore FALSE would show correct data! In order to correct my issue needed to add the wild card asterisk to eliminate "hidden"leading or trailing spaces or characters in my part number column.16KViews0likes1CommentRe: TRUE vlookup brings the wrong results
The item for the look up is a part number. There are no duplicates. Some are similar (ie, 3M712 & 3M712-002CZ. Using TRUE brings closest matches for all rows. But then changing to FALSE, get all rows #N/A. I need exact matches and there are exact matches in the full data sheet.16KViews0likes0CommentsRe: TRUE vlookup brings the wrong results
You are having the same issue that many people are experiencing. The answer should be simple, but it is NOT. I have a few people looking at this issue and we hope to discover a solution! I only mentioned the page id because Microsoft Excel VLOOKUP Refersher mentions getting the name correct; which of course I have done. Agree the name ID is not the problem! I was just looking for a solution. Hopefully someone with reply and tell us the issue with our VLOOKUP formula!16KViews0likes0CommentsRe: TRUE vlookup brings the wrong results
Having the very same issue using TRUE I have used FALSE to get an "exact" match for each row, but the results are #NA. I think this might be a formatting issue for the data sheet. Or maybe the problem with the Page ID number. =VLOOKUP(A2,costing!$A$2:$B$3000, 2, FALSE) Appreciate any help!16KViews0likes10Comments
Recent Blog Articles
No content to show