I am trying to do a vlookup function with data that is imported and
calculated from another cell, and it shows a result of #na.

c3 is formated to custom "m" to show the number of the month from cell
b3.

b3 is "October-04" c3 shows "10" d3 "job name"

b100 "10"
a100 =vlookup(b100,c3:f20,2,false)

result is "#na"

If I enter "10" into cell c3 with format set to general, then the
result shows the correct answer.

Is there a way to correct this?


--
comotoman
------------------------------------------------------------------------
comotoman's Profile: http://www.excelforum.com/member.php...o&userid=27292
View this thread: http://www.excelforum.com/showthread...hreadid=472676