[avisitor]

I'm trying to do something really simple, but for some reason I'm having the hardest time figuring out how to do it. I need to select rows from one sheet based on another spreadsheet. This is the schema:

Sheet 1:

ID, Last, First, Username

Sheet 2:

Last, First


I need a way to get all the rows in Sheet 1 that match a row in Sheet 2. I imagine there's an easy way to do this, but I can't think of it.

[Ziggy1]

I think you want to use a Vlookup formula.


Look at what I attached, notice that I create a new field in each sheet to concatenate the First/last names into one field....you could do it with a longer formula separately, but I am lazy so I do it like this.


I just revised the formula slightly,

=VLOOKUP($E2,Sheet2!$A:$D,1,FALSE)

I made it so in sheet 2 it refers to columns A to D, then the number in Red ( above) is the column number from sheet 2, so you can copy this formula to right in sheet 1 and change the column number so you can pull in the next column from sheet 2.... hope it makes sense.

if this isn't what you need, then we'll have to give you some code I think.

[avisitor]

That, with minor variations did exactly what I was looking for. Thanks a lot. You saved me from having to write a real headache of a program in VBA.

I ended up changing the schema as follows.

Sheet 1:

ID, Concat, Last, First, Username,

Sheet 2:

Last, First, Concat

Then, in the fourth column in Sheet 2, the following VLOOKUP: =VLOOKUP(C1,Sheet2!B:E,4)