microsoft_excel:vlookup:vlookup_with_numbers_and_text
This is an old revision of the document!
Microsoft Excel - VLOOKUP - VLOOKUP with numbers and text
A common problem with VLOOKUP is a mismatch between numbers and text.
Either the first column in the table contains lookup values that are numbers stored as text, or the table contains numbers, but the lookup value itself is a number stored as text.
Try
=VLOOKUP(val&"",table,col,0)
Try
=VLOOKUP(value(val),table,col,0)
microsoft_excel/vlookup/vlookup_with_numbers_and_text.1608545784.txt.gz · Last modified: 2020/12/21 10:16 by peter