microsoft_excel:vlookup:vlookup_with_numbers_and_text
Differences
This shows you the differences between two versions of the page.
| Both sides previous revisionPrevious revisionNext revision | Previous revision | ||
| microsoft_excel:vlookup:vlookup_with_numbers_and_text [2020/12/21 10:18] – peter | microsoft_excel:vlookup:vlookup_with_numbers_and_text [2020/12/21 10:25] (current) – peter | ||
|---|---|---|---|
| Line 25: | Line 25: | ||
| =VLOOKUP(value(val), | =VLOOKUP(value(val), | ||
| </ | </ | ||
| + | |||
| + | ---- | ||
| + | |||
| + | Try | ||
| + | |||
| + | < | ||
| + | =VLOOKUP(TEXT(val," | ||
| + | </ | ||
| + | |||
| + | ---- | ||
| + | |||
| + | Try | ||
| + | |||
| + | < | ||
| + | =VLOOKUP(TEXT(val,"#" | ||
| + | </ | ||
| + | |||
| + | ---- | ||
microsoft_excel/vlookup/vlookup_with_numbers_and_text.1608545932.txt.gz · Last modified: 2020/12/21 10:18 by peter