Differences

This shows you the differences between two versions of the page.

--- microsoft_excel:vlookup:vlookup_with_numbers_and_text [2020/12/21 10:16] – created peter
+++ microsoft_excel:vlookup:vlookup_with_numbers_and_text [2020/12/21 10:25] (current) – peter
@@ Line 12: / Line 12: @@
 =VLOOKUP(val&"",table,col,0)
 </code>
+<WRAP info>
+**NOTE:**  Concatenating an empty string to the lookup value converts the lookup value to text.
+</WRAP>
 ----
@@ Line 20: / Line 25: @@
 =VLOOKUP(value(val),table,col,0)
 </code>
+----
+Try
+<code>
+=VLOOKUP(TEXT(val,"@",table,col,0)
+</code>
+----
+Try
+<code>
+=VLOOKUP(TEXT(val,"#"),table,col,0)
+</code>
+----