Forum Discussion
VLOOKUP #N/A after copy and paste
Hi there,
When I tried to copy and paste the table, the copied table showing #N/A which I am not sure how to fix it. This is a naming convention format that our organization use.
opun966 I suspect that the look_up range should be A2:B12. You have to make it absolute if you want to be able to copy down to the next campaign. Change it to $A$2:$B$12 so that it remains the same and not increment the row references by 7 each time you copy it down.
2 Replies
opun966 I suspect that the look_up range should be A2:B12. You have to make it absolute if you want to be able to copy down to the next campaign. Change it to $A$2:$B$12 so that it remains the same and not increment the row references by 7 each time you copy it down.
Riny_van_Eekelen problem solved! Thanks so much 🙂
