Vlookup - value not available

[John Davis]

Hello All:

I was trying to use VLOOKUP to extract items in a spreadsheet sent to me for editing. There's a small green comment which states "A value is not available to the formula or function". Can anyone provide assistance. What does it mean and how do I get the VLOOKUP to work?

 

[John Davis]

hello all:

I was trying to use vlookup to extract items in a spreadsheet sent to me for editing. There's a small green comment which states "a value is not available to the formula or function". Can anyone provide assistance. What does it mean and how do i get the vlookup to work?

bump

 

[Gerald Higgins]

What does the cell itself show ?
Does it show
#N/A ?

If so, this probably means that the lookup value can not be found in the list.

 

[John Davis]

What does the cell itself show ?
Does it show
#N/A ?

If so, this probably means that the lookup value can not be found in the list.

Thanks for the reply. However, I figured it out. Leading spaces in the data.