Hello,
I am using the following formula<?xml:namespace prefix = o ns = "urn:schemas-microsoft-comfficeffice" /><o></o>
=IF(C8=0,"",VLOOKUP(C8,F9:G28,2,0))<o></o>
When I copy the formula down to the next row the table array is changing as well as the rest of my values. <o></o>
So the next row will look like this
=IF(C9=0,"",VLOOKUP(C9,F10:G29,2,0))<o></o>
But it should actually look like this<o></o>
=IF(C9=0,"",VLOOKUP(C9,F9:G28,2,0))<o></o>
Am I copying my formula wrong or what do I need to do to paste it without my table array changing?<o></o>
I am using the following formula<?xml:namespace prefix = o ns = "urn:schemas-microsoft-comfficeffice" /><o></o>
=IF(C8=0,"",VLOOKUP(C8,F9:G28,2,0))<o></o>
When I copy the formula down to the next row the table array is changing as well as the rest of my values. <o></o>
So the next row will look like this
=IF(C9=0,"",VLOOKUP(C9,F10:G29,2,0))<o></o>
But it should actually look like this<o></o>
=IF(C9=0,"",VLOOKUP(C9,F9:G28,2,0))<o></o>
Am I copying my formula wrong or what do I need to do to paste it without my table array changing?<o></o>