Forum Discussion
How do I paste data in excel column without changing the formula
So I have this vlookup column and some values didnt return properly where the n/A’s are. I’m trying to mammually paste the data or type it in but everytime I do, the rest of numbers disappea...
You have entered a range in your VLOOKUP() formula for which you want to perform the search and should use a single cell. The syntax of the function is like this:
VLOOKUP (lookup_value, table_array, col_index_num, [range_lookup])
You have entered a range for lookup_value. The result spills down. If you perform your search on a single cell, you will only get a single result. You must then copy the formula down as far as necessary. Now you can overwrite a single N/A# without disturbing the other calculations.
So my only option is to drag the formula down as far as the n/a and then do it again until the next n/a?