XLookup/Vlookup autopopulating
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.
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. Read More