Forum Discussion

Joseph2881's avatar
Joseph2881
Copper Contributor
May 28, 2024

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.

  • dscheikey's avatar
    dscheikey
    Bronze Contributor

    Joseph2881 

    Upload Files here:

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

Resources