Return "Gender" Value From a "First Name/Gender" Reference Table

Kawan

New Member
Joined
Nov 17, 2021
Messages
6
Office Version
  1. 2019
Platform
  1. MacOS
Hi everyone,

I am having troubles with something in Excel.

I have a list of thousands of people (some with similar first and last names of course) and I have a gender column that I would like to fill out based on another table in the same worksheet that I made (see attachment name "Main table"). That other sheet (see attachment called "reference table") just contains each first name (only once) to which I assigned a Male or Female gender value (let's not make it more complicated with other types of gender).
I am trying to populate my main table which contains many times the same first name with the appropriate gender based on the reference table that has the gender value I am looking for.

Does anyone know how to populate the gender column of my main table (located in the "Results" worksheet) by using as a reference the table on my "Names Gender" sheet that contains the value I am looking for. So for example, for all the first name "Aakash" the gender column should return male based on the table in the "Names Gender" sheet.

I hope my question is clear, if not please do not hesitate to ask me for more clarification.

Thank you,
Kawan.
 

Attachments

  • Main Table .png
    Main Table .png
    88.3 KB · Views: 10
  • Reference Table.png
    Reference Table.png
    177.3 KB · Views: 10

Excel Facts

What is the last column in Excel?
Excel columns run from A to Z, AA to AZ, AAA to XFD. The last column is XFD.

bstory84

Active Member
Joined
Oct 31, 2011
Messages
447
Office Version
  1. 365
Platform
  1. Windows
In cell M2 of your table
use this formula
Excel Formula:
=VLOOKUP([@[FIRST NAME]],'Names Gender'!A:B,2,0)
 
Solution
Master Excel Bundle

Excel contains over 450 functions, with more added every year. That’s a huge number, so where should you start? Right here with this bundle.

Forum statistics

Threads
1,152,115
Messages
5,768,200
Members
425,459
Latest member
Danniey

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top