Two sheets with a dropdown question?

[bultm35431]

Here is the question I have 6 sheets lets call them:

Master, sheet1, sheet2, sheet 3, etc.


Sheet1 is populated based off a dropdown on the Master fills out multiple rows.
Sheet2 is populated based off a different dropdown on the Master fills out multiple rows.
These are both user dependent.

Populates the first name and last name, DOB, age, and a bunch of other information.

If a name that is in sheet 2, happens to be sheet 1, I want to pull a piece of data off of a column M on sheet 1 and put it in column M in sheet 2.

Some sort of name compare.........I just don't know how I go about doing that easily.

Thanks a bunch looking forward to learning from the reply or replies

[Lemice]

Hello bultm35431,

You can do so by using lookup functions such as Vlookup, Hlookup, Index with Match, etc, for example, if you want to compare a name in cell A2 of Sheet2 with a column of name on Column A in Master, if match, return a value in column B, an example is this

=Index(Master!B:B,Match(A2,Master!A:A,0)

You can always search for Lookup, Vlookup, Hlookup, Index and Match using search engine for more examples about them.

Beside that, if you have any other question, don't hesitate to post it here. If you have a sample workbook with a few unique dummy data, that'll be much easier too.

Cheers