Forum Discussion
Use numerical lookup with VLOOKUP?
I would like to populate a sample information array based on a numerical sample ID. However, when I use a VLOOKUP function with a numerical lookup (see screenshot), I get a bizarre result where init...
Weird. Yes you can use VLOOKUP for numerical values. I am assuming everything both sets of values are formatted as numbers. I was able to recreate this issue by changing between text and number formatting, same as you it only effects the last few numbers. Changing formatting does not fix it, oddly double clicking into 11,12 and 13 (In the table array) and hitting enter fixes it for me. Very strange.
See my edited post.
