Active6 years, 4 months ago
Conquer some of the most daunting features in Microsoft Excel: formulas and functions. In this Excel for Mac 2016 update to his popular series, author Dennis Taylor presents numerous formulas. If your lookup value is number format, and the ID number in the original table is stored as text, the above formula will not work, you should apply this formula: =VLOOKUP(TEXT(G1,0),A2:D15,2,FALSE) to get the correct result as you need.
I wanted to know if there was a way to use a vlookup on text values. Normally, I have been converting my text values to a number and then doing a vlookup, but this can be time consuming. For example, if i have a column of numbers (formatted as text) like 100-4333-239 I have been removing the '-' and converting to a number and then doing a vlookup. Is there a way to look up text without all the converting?
Jump to a specific line sublime text for mac. Thank you.
Chris2015Excel For Mac Free Download
Chris2015Vlookup Text Excel For Mac 2016
56477 gold badges1616 silver badges3535 bronze badges
1 Answer
![Strike Strike](/uploads/1/2/6/0/126019639/922861677.gif)
The last argument determines whether
VLOOKUP
should find 'approximate' matches as well (which is, in my opinion, a bad description -- passing TRUE
there or leaving the argument out seems to tell Excel that the table is sorted). In practice, this means that you should pass FALSE
when searching for text:Zsh has lots of other great features, too — and it's free, open source, and supplied as part of Mac OS X. Mac search files for text.
should give you 'THERESULT' if you have '100-4333-239' in cell B4 and 'THERESULT' in cell C4:
![Vlookup Vlookup](/uploads/1/2/6/0/126019639/186469726.png)
9,05111 gold badge2626 silver badges5858 bronze badges
Got a question that you can’t ask on public Stack Overflow? Learn more about sharing private information with Stack Overflow for Teams.