flaviooooo
Programmer
Hey, I have a problem in Excel 97. I have a query on a table. Now i have to get some figures from several months in a year, but if the month is not in the table, then i get a #N/A in the cell. I'd rather have a 0 then.
I use following code to get the data:
IF(VLOOKUP(J$21;$P$2:$BK$13;4;FALSE) in which J$21 contains the number of the month, and $P$2:$BK$13 is the range.
can I fix this problem with an IF-statement(i tried), or can i alter the table so that is automatically gives all 12 months when i query it...?
help!
I use following code to get the data:
IF(VLOOKUP(J$21;$P$2:$BK$13;4;FALSE) in which J$21 contains the number of the month, and $P$2:$BK$13 is the range.
can I fix this problem with an IF-statement(i tried), or can i alter the table so that is automatically gives all 12 months when i query it...?
help!
