Difficult due to confidentiality.

Basically I need to know which patients from spreadsheet B are also in spreadsheet A and the one field that is in both sheets is the hospital number.

It wont be that many beacuase sheet B only has about 80 patients (sheet A has over a thousand) so when I have identified them I can manually extract the data if its easier - Its just the cross referencing that I want to do most.

Thanks