Excel Function to filter and extract data

[lumk]

Hi I am very new to excel and would appreciate some help.

I have 2 sheets in my spreadsheet : Data and Filter.

The Data sheet contains a bunch of raw data organized by Unique ID, Name, Address, Postal Code, Country, Date of Birth, Email.

I need to be able to filter this data by Unique ID on the filter sheet. I would like to be able to populate the Unique ID in the Unique ID column, and have it automatically extract and populate the corresponding information Name, Address, Postal Code, Country, Date of Birth, Email on the adjacent cells.

The only unique identifier is the Unique ID and there will be a lot of raw data.

I have attached the spreadsheet as an example of what I would like to do.

Thank you! K

[Gregb11]

Since you have O365 you can use the new XLOOKUP formula. In B2 you can type this formula:

=XLOOKUP(A2,Data!$A$2:$A$8,Data!$B$2:$G$8,"Not Found",0)

This will fill in the whole row. You just copy it down as far as you have ID's entered.