VLookup returning with "NA"
 

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.

VLookup returning with "NA"
 

It can be very tricky when it comes to 'precision as displayed'. I am pretty
good at vlookup. If you don't mind, you can send me your file. I will fix it
for you.

"Bridget" wrote in message
...
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.

VLookup returning with "NA"
 

Are you looking for an exact match or a nearest match in the VLOOKUP?

--
HTH

Bob

(there's no email, no snail mail, but somewhere should be gmail in my addy)

"Bridget" wrote in message
...
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.

VLookup returning with "NA"
 

I was looking for exact. Apparently, I need to put a $ in from of the array
for some reason. Anyway, that worked!!! Thanks for replying

"Bob Phillips" wrote:

Are you looking for an exact match or a nearest match in the VLOOKUP?

--
HTH

Bob

(there's no email, no snail mail, but somewhere should be gmail in my addy)

"Bridget" wrote in message
...
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.

VLookup returning with "NA"
 

THanks for the offer. Someone told me to put a $ in from of the array range
and that worked . . .for whatever reason : )

"LLee2" wrote:

It can be very tricky when it comes to 'precision as displayed'. I am pretty
good at vlookup. If you don't mind, you can send me your file. I will fix it
for you.

"Bridget" wrote in message
...
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.