Occasional Visitor

i am trying to revise for my higher administation and IT test and have to do this vlookup where i have to copy the information for the first picture into the second one. the first vlookup was successful but when i scroll down it says NA how do i fix this and why is it happening.Screenshot 2023-01-12 13.38.07.pngScreenshot 2023-01-12 13.37.05.png

1 Reply


In D4:


=VLOOKUP(A4, 'Sponsorship Details'!$A$4:$C$6, 3, FALSE)