SOLVED

VLOOKUP #N/A after copy and paste

Copper Contributor

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_0-1694050650882.png

opun966_1-1694050667357.png

 

 

2 Replies
best response confirmed by Hans Vogelaar (MVP)
Solution

@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 :)

1 best response

Accepted Solutions
best response confirmed by Hans Vogelaar (MVP)
Solution

@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.

View solution in original post