need to pull information from two separate spreadsheets using the same patient information

That did not work. I have been trying different ways of VLOOKUP and either I am just doing it wrong or that is not the way to do what I need to do.