I am basically trying to rec rows of two seperate files together to see if there are any differences between the two.
I have a VLOOKUP built that seems to do the job most of the time, but after recing say 4-5 rows, it all of a sudden throws #N/A
I can get this to go away by retying over the formula for each of the rows, but it seems very silly... I am hoping I am missing something silly here...
Ex.
First Colum:
=VLOOKUP(C67,'UAT FX & FX OPTIONS'!A22:DJ230,2,FALSE)
2nd Column:
=VLOOKUP(C67,'UAT FX & FX OPTIONS'!A22:DJ230,3,FALSE)
3rd Column:
=VLOOKUP(C67,'UAT FX & FX OPTIONS'!A22:DJ230,4,FALSE)
Etc...
Right now it resulting value is showing #N/A, but if I go into each of these cells and retype the formula I am getting the value I need.
Also if there was an easy way to track the formula across the row, I am trying to reconcile 75 columns of data in the rows.
Again you guys are great, and appreciate any pointers.
I have a VLOOKUP built that seems to do the job most of the time, but after recing say 4-5 rows, it all of a sudden throws #N/A
I can get this to go away by retying over the formula for each of the rows, but it seems very silly... I am hoping I am missing something silly here...
Ex.
First Colum:
=VLOOKUP(C67,'UAT FX & FX OPTIONS'!A22:DJ230,2,FALSE)
2nd Column:
=VLOOKUP(C67,'UAT FX & FX OPTIONS'!A22:DJ230,3,FALSE)
3rd Column:
=VLOOKUP(C67,'UAT FX & FX OPTIONS'!A22:DJ230,4,FALSE)
Etc...
Right now it resulting value is showing #N/A, but if I go into each of these cells and retype the formula I am getting the value I need.
Also if there was an easy way to track the formula across the row, I am trying to reconcile 75 columns of data in the rows.
Again you guys are great, and appreciate any pointers.
