I am trying to make a formula that may need LOOKUP,INDEX and MATCH functions.

I am trying to make a formula that will look up peoples names and their relevant info. They are sorted into groups on sheet1 ,Named group 1 , group 2 ect. On sheet 2 when I enter the group name in cell C4 I need to have a formula list up the peoples relevant info like if they are male or female, Birthday and a few others as well.

Then on sheet3, I only want to enter a single persons name and have their data be brought up.

I have simplified the workbook, as there is a lot more info to enter other than birthdays ect, plus there are thousands of peoples data that has to be entered, so I need to be able to expand the lists ect as the list of people grow.

TIA.

How would you suggest I rename the title b/c I thought it was clear in stating my problem? That is the hardest part when I am posting on this forum, b/c I am trying my best to abide by the rules. I write what I did b/c it allows people who read the title to give an idea of if they could help me or not, I do not think that it has similarities to these examples given in the rules "Please Help, Urgent, Need Help, Formula Problem".

Edit, never mind I changed the title from "LOOKUP , INDEX formula, possibly use MATCH as well." to the one it has now.

JapanDave,

Your thread titles may be conversational, but they are useless for anyone searching for a solution to a similar problem. Please compose thread titles that describe your problem without enumerating the all the ways it might be solved. Doing so will avoid future threads being closed while you reconsider. All of the "I am trying", "I need a", "Need to know how to" is clutter.

For this thread, for example, "Lookup associated data" would be a relevant title.

Thanks.

We agree but that's why rules say: Your post title should accurately and concisely describe your problem, not your anticipated solution. so you can easily give appropiate title (without knowing what formula will be used... Mostly, a solution is far opposite than you imagine at the first time)...

(just imagine what would someone else write in search box to find your thread)

Your post does not comply with Rule 1 of our Forum RULES. Your post title should accurately and concisely describe your problem, not your anticipated solution. Use terms appropriate to a Google search. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will be addressed according to the OP's experience in the forum: If you have less than 10 posts, expect (and respond to) a request to change your thread title. If you have 10 or more posts, expect your post to be locked, so you can start a new thread with an appropriate title.
To change a Title on your post, click EDIT then Go Advanced and change your title, if 2 days have passed ask a moderator to do it for you.

68 posts you should know by now