Populating table with data using multiple criteria

[skip13]

Hi,

I am attempting to populate multiple rows in one column with data from another table. I need to get the correct street address using multiple values, i.e. first name, last name and city, as some of the names double up.

Is there a way to do this? I have attached an example of what I need done as reference.

Thanks in advance,
Joey

[Lemice]

Hello,

You can do this by using a simple Array formula, like this

Please Login or Register  to view this content.

Paste it on C2, click on the formula bar, hold Ctrl-Shift and hit Enter. If you see the formula being wrapped inside a { } then you did it right.

Afterward, you can drag it down to C5.

Here is your sample file with the formula.

Edit: I suggest you try mama's formula on post #3 (right below this), because it is better.

[Teethless mama]

C2: =LOOKUP(2,1/(A$13:A$16=A2)/(B$13:B$16=B2)/(D$13:D$16=D13),C$13:C$16)

Normally Enter
Copy down