VLOOKUP formula not working

[Eurekaonide]

Hi All

I have the following set of formulas and for soem reason its not working - I think it must be to do with something around the order (i.e. Ascending etc) as it works if I just type a number in but I need it to fine the number automatically.

First Cell = H40

=CurrRepPeriod (Which relates to another cell where a number is typed manually between 1 and 12)

Second Cell = H42

=VLOOKUP(H40,Sheet2!$B$7:$D$18,3,FALSE)

(This works fine)

Third Cell = H36

=IF(H40=1,"12",(H40-1))

(This needs to notice if the previous cell H40 is showing 12 then it needs to go back to 1) (This works fine)

Fourth Cell = H38

=VLOOKUP(H36,Sheet2!$B$7:$D$18,3,FALSE)

(this returns #NA where I want it to look back down the same table as before and pick up the data which is in relation to number 12)

Any ideas??

 

[Andrew Poulsom]

Try removing the double quotes around 12 in this formula:

=IF(H40=1,"12",(H40-1))

Surrounding a number in double quotes makes it a string.

 

[Eurekaonide]

Fantastic
thanks very much