Hello all.

main.jpg

clients.jpg

The upper image is from the main tab and the lower is clients.

I need column d to show the serial number from the corresponding location from the clients tab.

The formula I have for d23 is:

=INDEX(Clients!$B$1:$B$379,MATCH(A23,Clients!$A$1:$A$379))
As you can see D23 is returning a #N/A while the rest are shifted 1 down from where they should be.

I cannot use copy/paste from clients to main since there are gaps in the numbers on the clients tab. If the cell could just be blank if there is no corresponding location on the clients tab that would be great too.

Any help would be greatly appreciated.

Thanks!