getting information for a table

[DEEARO]

Hi all,

I would like to say first thank you for your help, it is well apricated.

2 TABS
RAW DATA
FILTER

I have sheet of Raw Data and I want to select different names (the whole row) and present this information, please Filter sheet. At the moment I am coping and pasting the data however has the data grows it takes a long time. I am looking for formula which finds the Name and copy's the information.


Deepak

[CARACALLA]

filter

B5=IF(AND(filter!$A5<>"",filter!B$4<>""),SUMPRODUCT(('raw data'!$A$3:$A$88=filter!$A5)*('raw data'!$B$2:$J$2=filter!B$4)*('raw data'!$B$3:$J$88)),"")

copy across and down

[DEEARO]

Hi Caracalla,

this is exactly what I wanted, thank you.

However there is an issue, 2 of the columns are not getting the correct information (c7 and c8)


Your help will be apricated.

Thank you once again

[CARACALLA]

In your file xxx2 is present 2 times and then

the formula does the sum

[DEEARO]

Hi Caracalla,

I did not see my mistake in naming the headings,

This is exactly what I wanted, thank you.

Thank you once again

[CARACALLA]

only for office 365 with double or not headings.

filter


B7=FILTER('raw data'!B3:J88,'raw data'!A3:A88=filter!A7,"")

[DEEARO]

Hi Caracalla,

I have some trouble editing the formula to work on my workbook.


the formula is not dragging across correctly.

I have Microsoft Office 2016 at work

[Bo_Ry]

Please try

=FILTER('Raw Data'!C40:J674,ISNUMBER(MATCH('Raw Data'!$A40:A674,A5:A14,)))

[DEEARO]

Hi Bo_Ry

I had to edit the headings and it went wrong. please have a look

the below function doesn't work: states function not available
=FILTER('Raw Data'!C40:J674,ISNUMBER(MATCH('Raw Data'!$A40:A674,A5:A14,)))

[Bo_Ry]

Try
=VLOOKUP($A5,'Raw Data'!$A$40:$J$674,MATCH(B$4,'Raw Data'!$A$39:$J$39,))

[DEEARO]

Hi Bo_RY,

thank you for your reply. the formula almost works. the issue I found is that it is not matching the names correctly. I have placed two names not in Raw Data table but the Filter is still finding results.

your help will be apricated