User Profile

JoB_19

Copper Contributor

Joined Jan 05, 2019

6 Posts1 LikeLikes received

View All Badges

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.
Jan 08, 2019 Place Excel
16KViews
0likes
1Comment
Re: TRUE vlookup brings the wrong results
Updating by taking out the space before the *. =VLOOKUP(A2&"*",costing!$A:$B,2,FALSE) Let me know if this helps with your VLOOKUP.
Jan 07, 2019 Place Excel
16KViews
0likes
4Comments
Re: TRUE vlookup brings the wrong results
Found the solution!!! To be honest, my sister did! Teamwork is great! This formula fixed the issue. =VLOOKUP(A2&" *",costing!$A:$B,2,FALSE) Hope this helps others at the Microsoft board.
Jan 07, 2019 Place Excel
17KViews
1like
7Comments
Re: 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.
Jan 06, 2019 Place Excel
17KViews
0likes
0Comments
Re: 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!
Jan 05, 2019 Place Excel
17KViews
0likes
0Comments
Re: 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!
Jan 05, 2019 Place Excel
17KViews
0likes
10Comments

Recent Blog Articles

No content to show