I am fairly new to Excel.

I think what i want to do should be simple.

I have 2 spreadsheets about pateint data. one includes certain pateints (A) and one contains patients who have had a certain type of procedure (B). Both have a row containing the hospital number. If the patients in B appear in A, I want to extract all the other data from B into a third spreadsheet.

Any help greatly appreciated.

Andy