B
Bridget
Hi,
I am fairly new at VLookup. In a list of various numbers I am looking up
(ranging from 0-900), only numbers that are two digits or start with a 1 or a
2 are retuning as 'NA'. I've tried the 'trunc' and setting 'precision as
displayed' per Microsoft help but that isn't working either. I tried making
sure the formatting of both lists are set as a general number/number.
Nothing is working.
This is what is displaying:
484 10,376.21
74 #N/A
872 8,230.62
872 8,230.62
167 #N/A
618 10,482.50
552 4,681.12
871 10,440.70
348 7,632.27
26 #N/A
194 #N/A
289 13,779.41
This one row example of my table array the vlookup is pulling from (which is
in ascending order):
69 Transient ischemia
Thank you.
I am fairly new at VLookup. In a list of various numbers I am looking up
(ranging from 0-900), only numbers that are two digits or start with a 1 or a
2 are retuning as 'NA'. I've tried the 'trunc' and setting 'precision as
displayed' per Microsoft help but that isn't working either. I tried making
sure the formatting of both lists are set as a general number/number.
Nothing is working.
This is what is displaying:
484 10,376.21
74 #N/A
872 8,230.62
872 8,230.62
167 #N/A
618 10,482.50
552 4,681.12
871 10,440.70
348 7,632.27
26 #N/A
194 #N/A
289 13,779.41
This one row example of my table array the vlookup is pulling from (which is
in ascending order):
69 Transient ischemia
Thank you.