Lookup query

[oceanswims]

I have two workbooks each containing the same database of people. In each, each person's name is split between two fields, forename and surname. One workbook also has DoB. I want to look up each person's DoB from one workbook to the other, ie I want to use the forename and surname fields to look up the DoB from the other workbook.

Any advice appreciated.

[#2]

@oceanswims I'd go for INDEX/MATCH or FILTER (if your Excel version already supports it). Both are demonstrated in the picture below.

Book1 looks up the DoB in Book2 based on the Fist and Last names. I've used named ranges First, Last and Dob in both workbooks to make referencing easier.

[#3]

@Riny_van_Eekelen Thank you. I'll have a close look at that.