XLookup/Vlookup autopopulating

Copper Contributor

I am creating a database for Genelogical purposes and I have someone that would like to use my database to allow searching for people in their cemetary.

 

I would like to take the first tab (Search), where at the top I have fields marked Last, Maiden, First, Middle, AKA, DOB and DOD. I wish to have these cells where people would type information they know.

 

Then below that there is a table with more fields. I wish to have this table populated off of my A-Peterson, & Petree-Z tabs based off what the user will input into the search cells.

 

I am somewhat familiar with formulas though not entirely positive how I would build these formulas. 

 

Please Help.

 

P.S. If I can figure out how to attach a copy of the database to aid in getting assistance I will.

1 Reply

@Joseph2881 

Upload Files here:

dscheikey_0-1717005256564.png

Please be careful when calling a spreadsheet a database. This usually leads to a shitstorm.