The link below has some solutions;
https://exceljet.net/formula/vlookup-with-numbers-and-text
TL;DR,
=IFERROR(VLOOKUP(id,planets,3,0),VLOOKUP(id&"",planets,3,0))
Showing posts with label type. Show all posts
Showing posts with label type. Show all posts
Sunday, 30 July 2017
Type errors when using VLOOKUP
When using VLOOKUP it will only find matches of the same data type as source.
The link below has some solutions;
https://exceljet.net/formula/vlookup-with-numbers-and-text
TL;DR,
The link below has some solutions;
https://exceljet.net/formula/vlookup-with-numbers-and-text
TL;DR,
Subscribe to:
Posts (Atom)