Lookup and return entire table

[ocean000]

Hi, I'm trying to lookup and return an entire table.

excel.png

What I have here is a whole bunch of details of people in top few rows.

On the bottom I need to return the 9 pieces of information of 4 select persons exactly.

Any ideas here? Thanks.

I am using the online version.

[José Augusto]

Hi

Attach a sample workbook (not a picture or pasted copy). Make sure there is just enough data to demonstrate your need. Include a BEFORE sheet and an AFTER sheet in the workbook if needed to show the process you're trying to complete or automate. Make sure your desired results are shown, mock them up manually if necessary.

Remember to desensitize the data.

Click on GO ADVANCED and then scroll down to Manage Attachments to open the upload window.
Thanks,

[ocean000]

Here.

Desired results from A8:C10 needs to be repeated the exact same way as the data in rows 2-4.

[63falcondude]

Try this in A8:

=INDEX(2:2,MATCH($A$7,$1:$1,0)+COLUMNS($A:A)-1)

Drag the formula through C8 then down through C10.

Use the same logic for the other boxes.

See attachment.

[ocean000]

Thank you! Works great!

[63falcondude]

You're welcome. Happy to help.

If that takes care of your original question, please select Thread Tools from the menu link above and mark this thread as SOLVED.