I am having trouble producing the correct value when using the vlookup on multiple tabs it works fine on the same table any reasons why?

=UPPER(VLOOKUP('File List'!H4,'Line List from PID'!$D$4:$AA$772,3))