Im trying to do a vlookup for to bring up several colums of data to the right of the referenced cell, but i cant get the column munber to change when i copy the cell to the next column. is this possible?
#na doesn't mean you've got it wrong, it means there was not matching value. You can get round this if you want, but why bother - knowing that a value is not there is positive info, not an error (although post back if you do want to get rid of them)
the table reference in your lookup is
B2141:Y2154. This is a relative reference. (The absolute reference would look like $b$2141:$y$2154). I assume that you wrote this formula in a cell higher up in the spreadsheet & copied it down. If so the relative references will have changed & the vlookup's probably not looking in the right place any more. Change te references to absolute before you copy the formula down, or use a named range.